Page 1 of 1

Good way to run this search?

Posted: Mon Aug 01, 2005 7:29 pm
by 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!

Good way to run this search?

Posted: Mon Aug 01, 2005 10:03 pm
by 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 =+'

Good way to run this search?

Posted: Thu Apr 13, 2006 3:08 pm
by pete.smith
how about "C++" ?

Good way to run this search?

Posted: Thu Apr 13, 2006 3:51 pm
by mark
That should just work as long as you have an index expression that include +.