Good way to run this search?

[jkj2001]

Hi,

I'm trying to run a search in which the phrase has a plus sign in it, like so:

tsql "select * from mytable where myfield like '"Hello +"'"

Trouble is, I get a syntax error when I do that. I tried to escape the plus sign with a preceding backslash, but that didn't change things. Could you suggest a workaround? Thanks!

[mark]

like '"Hello +"'
would work (not being on the front of a term + is not special)
like 'Hello +'
would not and should be
like 'Hello =+'

[pete.smith]

how about "C++" ?

[mark]

That should just work as long as you have an index expression that include +.