Using "|" in a sql statement string

D

Dennis

Hi all. I have a little problem. I am trying to set a
field value to a string that contains a pipebar "|" and I
am having a problem doing so since SQL is taking the "|"
as an operator instead of a string.

Basically my sql statement looks like:

"Update ProductInfo Set ProductInfo.TagValue
= 'Choice1|Choice2' Where ProductInfo.TagName
= 'MEBChoices'"

and when I execute it I get a syntax error.

Can anyone shed some light on this problem for me? I have
tried to surround the text in both single and double
quotes and it has made no difference.

Thanks!
Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help using a pipebar in an update string!! 5
In search of a single SQL statement 0
Can I Build an Access Statement (in 2007) as a String and Execute 3
SQL statement needed 0
Using field name for IN text string in query criteria 10
Same SQL string works as form record source, but fils whe it is used to open form 1
Dynamically getting IN field list from text box on form 7
A SQL statement in VBA 7

Top