Viewing 2 posts - 1 through 2 (of 2 total)
isNull funcation for nullable value ... try then reply
June 10, 2009 at 4:06 am
#1007251
sunil,
You can use this style too....
set @Gender = isNull('M', '_')
set @Age = isNull(22, 0)
SELECT * FROM test_EmployeeDetails
Where Gender LIKE @Gender AND Age > @Age
Thanks!
Azeem
June 3, 2009 at 10:15 am
#1004157