Sql is not null problem

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Related Hot Network Questions. Question feed. I need to combine three columns representing address lines into one column, in order to compose the entire address here. All three columns can contain a NULL value.

I thought the way to go about this is as follows:. However, both instances of "Is" have a red squiggly underlining, indicating "Incorrect syntax near 'Is'.

I use SSMS It evaluates the Boolean expression passed as the first argument, and then returns either of the other two arguments based on the result of the evaluation. I found this as an answer to a question on checking for empty strings:. How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 3 years, 8 months ago. Active 2 years, 2 months ago.

Viewed 21k times. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 11 months ago. Active 1 year, 11 months ago. Viewed 35k times. Thanks in advance. Improve this question. Depends on a lot of things, as ever.

How you use it, where you use it, what your query is. More detail might help. SergioTulentsev I am working on an enhancement project. So we have added some new colomns to tbls. That will be Null. The data which is available for development is only few. The production Database is very huge. I cannot access to it. What is better? Don't optimise prematurely — gbn.

Harie - if you need to load up your DEV database, you might want to take a look at something like this: red-gate. Add a comment. Active Oldest Votes. Improve this answer. Heino Zunzer Heino Zunzer 1 1 gold badge 4 4 silver badges 4 4 bronze badges.

Note that these two conditions do not give the same results.