SQL detecting null value and change query

Question

i am using c# and mssql. i send parameters from c# to sql and execute a query but sometimes it comes null values. i m using sql like function. it is great for string values but has problems with bool. for example bool b = NULL query executes like that: .... WHERE B LIKE '%%' and it never returns a value. i want to detect null value and change query if b is null the query must be like that ...... WHERE B IS NOT NULL i could change this in c# code but there are some other parameters like that it could be easier in sql if it is possible

thanks

El Yobo · Accepted Answer · 2010-08-09 12:08:11Z

1

SQL server supports the standard SQL COALESCE function; try wrapping your boolean values in a coalesce call, e.g. WHERE COALESCE(bool_value, '') LIKE '%%'

answered Aug 9, 2010 at 12:08

El Yobo

15k6 gold badges65 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

D'Arcy Rittich · Accepted Answer · 2010-08-09 12:06:27Z

1

Use parameterized queries and all of this is taken care of for you.

answered Aug 9, 2010 at 12:06

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Collectives™ on Stack Overflow

SQL detecting null value and change query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related