I have a need to add an additional value to a multi-valued field on a bunch of records. I was hoping I could do this using SQL UPDATE but it appears you have to explicitly list all the muli-values...
UPDATE FILE SET MVFIELD = <'FIRST', 'SECOND', 'THIRD', 'THE.NEW.VALUE'>; Anyone know of way to append a new value using UPDATE? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.com<http://www.zirmed.com/> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users