Arvind Singh Baghel

Arvind Singh Baghel

  • 595
  • 1.7k
  • 72.5k

where condition based on not null column

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

Answers (4)