06-11-03, 10:49 #1Registered User
- Join Date
- Jan 2003
Unanswered: problem with freetext() in where statement
I am trying to run this statement [blue]where freetext(field, @searchString)[/blue] only when @searchString is not empty.
It should work the same way as you can do with normal compare
[blue]where field = case @searchString when '' then field else @searchString end[/blue]