How can i query and display text if the column is null using case

Question

0.00/5 (No votes)

See more:

Good afternoon guys,

How can i query and (display or change) it into a dash if the data in the specific column is null using case?

Thank You, any suggestions and opinion, will be so much appreciated!.

Posted 18-Feb-13 18:48pm

Member 8076338

Add a Solution

Comments

Arun1_m1 19-Feb-13 0:51am

Can you let us know the exact output what is intended, this would be helpful in giving an exact solution.

__TR__ 19-Feb-13 0:59am

Try
SELECT CASE WHEN [YourColumnName] IS NULL THEN '-' ELSE [YourColumnName] END
FROM [YourTableName]

Sergey Alexandrovich Kryukov 19-Feb-13 1:05am

Null?! No kidding?
—SA

Member 8076338 19-Feb-13 4:13am

Thanks a lot guys, it works :)

I try Aarti Meswania and __TR__ posted. and it successfully works.

GOD BLESS.

2 solutions

Solution 3

Hi Friend,

Please try the below query,

SQL

select isnull(name,'')  from sales

Posted 18-Feb-13 20:23pm

Arul R Ece

Add a Solution

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

Aarti Meswania · Accepted Answer · 2013-02-18T19:04:00

Solution 2

SQL

select IsNull(ColNm,'-') from TblNm

--Or--

SQL

select case when ColNm is null then '-' else ColNm end as ColNm from TblNm

Happy Coding!
:)

Posted 18-Feb-13 19:04pm

Aarti Meswania

Comments

Member 8076338 19-Feb-13 4:06am

Thanks a lot guys, it works :)

How can i query and display text if the column is null using case

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

How can i query and display text if the column is null using case

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us