Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE

2011-09-13 Thread Charles Stevenson
Perry Taylor Sent: Thursday, September 08, 2011 10:11 AM To: U2 Users List Subject: [U2] [UV] Adding a multi-vaue using SQL UPDATE 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 expli

Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE

2011-09-13 Thread Perry Taylor
Hrm... no bites?? Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Thursday, September 08, 2011 10:11 AM To: U2 Users List Subject: [U2] [UV] Adding a multi-vaue using SQL UPDATE I have a

[U2] [UV] Adding a multi-vaue using SQL UPDATE

2011-09-08 Thread Perry Taylor
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