I wish to store a pipe char in an Access db using ODBC:
Insert Into T_Table (MemoField) VALUES ("A string with a pipe | ")
This gets rejected as it doesn't like the pipe, how do I do this?
whenever i try to write a SQL query with a text block containing the
pipe "|" character, the query fails with an error saying syntax error.
for eg. a query like
UPDATE MYTABLE SET MYFIELD = 'A|'
fails in Jet
the same query works in SQL Server
any clues as to what i am missing or some way to escape the pipe
character. Jet does not support the "ESCAPE" keyword