Hi!

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]

Any suggestions?