where condition based on not null column

Arvind Singh Baghel

Arvind Singh Baghel

Oct 6 2016 3:38 AM


I have table like Table1 and columns like Col1,col2,col3,col4,col5...upto col15
my pocedure valirable is @NP1 

now i want to check if col1is null or empty then check for col2... like upto col15

like select *from  table where Col1= @NP1
dont want to use isnull or case

Upload Source Code  Select only zip and rar file.
Answers (4)