How do you enter a string which has | (pipe) character in Access. The following stmt
update table1 set fld1 = 'abc|xyz' where fld2=somthing
works fine on Oracle and DB2 but pukes on Access.
TIA
Printable View
How do you enter a string which has | (pipe) character in Access. The following stmt
update table1 set fld1 = 'abc|xyz' where fld2=somthing
works fine on Oracle and DB2 but pukes on Access.
TIA
try this
(this is how I can pass quotes to SQL server)
"update table1 set fld1 = 'abc" & Chr(124) & "xyz' where fld2=somthing"
HTH
Tom
------------------
[email protected]
[qualifications and/or certifications here]