Sql select field value if not null

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I have an SQL database with 5 fields, I want a select statement that will choose value from one field if it is not null or else it will choose from second. I found the case condition but not sure how to state it.

SQL

SELECT CASE 
            WHEN tel is not null
               THEN select tel 
               ELSE select mob 
       END as Saleable 
FROM Product

What I have tried:

I have tried nothing so far but I would try the above code

Posted 23-Jun-16 19:28pm

Member 3892343

Updated 23-Jun-16 20:07pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2016-06-23T20:07:00

Solution 2

The simplest way is to use COALESCE function[^].

SQL

SELECT COALESCE(tel, mob) as Saleable 
FROM Product

Using CASE ... WHEN ... END statement:

SQL

SELECT CASE WHEN tel IS NULL THEN mob ELSE tel END as Saleable 
FROM Product

Posted 23-Jun-16 20:07pm

Maciej Los

Updated 23-Jun-16 20:09pm

v2

Comments

Karthik_Mahalingam 24-Jun-16 2:13am

Counter 5 for simpler solution.

Maciej Los 24-Jun-16 2:14am

Thank you, Karthik.

Karthik_Mahalingam · Accepted Answer · 2016-06-23T19:37:00

Solution 1

try this

SQL

SELECT CASE 
            WHEN tel is not null
               THEN   tel 
               ELSE   mob 
       END as Saleable 
FROM Product

Posted 23-Jun-16 19:37pm

Karthik_Mahalingam

Comments

Maciej Los 24-Jun-16 2:05am

Karthik, is there any difference to OP query? I do not see... ;(

Karthik_Mahalingam 24-Jun-16 2:08am

HI Maciej
I executed his code and it thrown syntax error, so i just removed the "select" and executed it gave the correct result.

Maciej Los 24-Jun-16 2:10am

I missed that "SELECT" is inside CASE... WHEN...END statement. Good catch!
A 4, because there's simplest way to achieve that ;)

Karthik_Mahalingam 24-Jun-16 2:12am

:) Thank You Maciej

Yes, Agree, i just edited OP's query..