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

On 19 Apr 2006 07:07:47 -0700, Igor wrote:

>Is there possibility to use IF conditions inside SELECT statements?
>
>For example, can i write something like this:
>CREATE PROCEDURE [search]
>(
>@OPTION int,
>@KEYWORD nvarchar(40)
>)
>AS
>BEGIN
> SELECT id FROM projects WHERE title LIKE @KEYWORD IF (@OPTION = 1)
>THEN (OR description LIKE @KEYWORD)
>END
>
>or am i limited to this:
>...
>BEGIN
> IF @OPTION = 1
> SELECT id FROM projects WHERE title LIKE @KEYWORD OR description LIKE
>@KEYWORD
> ELSE
> SELECT id FROM projects WHERE title LIKE @KEYWORD
>END

Hi Igor,

The latter will probably perform best. But if you prefer to have it in
one query, you can also use

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

For more complex cases, check out the CASE expression in Books Online.

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Using IF inside SELECT ?
• Prev in forum: Restoring Master on another machine...
• Thread view: Re: Using IF inside SELECT ?

[Reply to this message]