Tuesday, December 18, 2007

setting conditional value in variable - SQL

declare @s1 varchar(100)
declare @s2 varchar(100)
set @s1 = ''
set @s2 = 'A1'

set @s1 =case
when @s2='A' Then 'Rajesh'
when @s2='A1' Then 'Rishabh'
else 'Kum' end
print @s1

No comments: