where clause to accept null or not null

arkiboys 9,706

Hello, I have created a stored proc which is a sql query with joins and where clause i.e Is there an error in my stored proc User's image

Olaf Helper 47,436 Reputation points

2024-01-26T07:50:24.4566667+00:00

Is there an error in

Do you get an error message and if, which one? Please post code as "code", not as a screenshot. As Viorel wrote, there is a space in front of ", gyt"

Accepted answer

Viorel 122.6K Reputation points

2024-01-26T06:59:31.55+00:00

Try to add LTRIM or TRIM here: ...select trim(value) from string_split....
Please sign in to rate this answer.

1 person found this answer helpful.
arkiboys 9,706 Reputation points

2024-01-26T07:13:19.2766667+00:00

this seems to be working. I am checking further...Is it best to use: nullif(@book,'') is null rather than @book is null ?

Viorel 122.6K Reputation points

2024-01-26T07:27:07+00:00

I think that @book is null can be kept.

arkiboys 9,706 Reputation points

2024-01-26T07:57:58.75+00:00

thank you
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer