Arvind Singh

Arvind Singh

  • 322
  • 5.7k
  • 777.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)