Wednesday, March 7, 2012

freetext

I don't know whether this is the right place to ask this question. I didn't get the answer from sql forums may be someone here can help.
I need to use freetext on two columns

something like

freetext(column1+column2,@.Search)

this will give error "Incorrect syntax near '+'."

Any One know the correct syntax.

Thanks

According tothe documentation, you use a comma-separated list enclosed in parentheses:

freetext( (column1, column2) , @.Search )

No comments:

Post a Comment