question on NULL

[habesha]

I have a local variable say @var

I want to select some data from a table XY based on the values of these local variable. The values for the local variable can be NULL or have data

Here is what I want, I want to write a single query to select data from the table only if the variable is not null otherwise I won't select. how calI do that

Thanks
teddy

 

[SQLDenis]

if @var is not null
begin
select * from table where SomeColumn = @var
end

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[GeertVerhoeven]

Another possibility is:

select * from table where SomeColumn = @var and @var is not null

Greetz,

Geert

Geert Verhoeven
Consultant @ Ausy Belgium

My Personal Blog