Posted by Hugo Kornelis on 10/02/90 11:45

On Wed, 19 Apr 2006 16:33:26 +0200, Hugo Kornelis wrote:

>SELECT id
>FROM projects
>WHERE title LIKE @keyword
>AND ( @option <> 1 OR description LIKE @keyword )

Oops, I misread the question. Use Helmut's version instead.

--
Hugo Kornelis, SQL Server MVP

[Back to original message]