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