If a search string can be null

http://www.thescripts.com/forum/thread81525.html

-- If a search string can be null
if @shortaddress is null
	select @addid = addid from address
	where shortaddress is null
else
	select @addid = addid from address
	where shortaddress = @shortaddress 

-- can be replaced with
select @addid = addid from address
where isnull(shortaddress,'@£$' ) = isnull(@shortaddress,'@£$' )
-- (where '@£$' is a value, which is not possible to get in that column)
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: