Access and | (pipe) character

[Ghost]

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

[Clunietp]

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]