need help in sql query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

hi ,
i have table called Product, in that table i have two columns named first column:-Product Description, and second column :- Product name.

i need to display Product Name if front end if it is null values in db i need show product description , any one help me to write this query

Posted 13-Aug-12 18:20pm

nrkhi401

Add a Solution

Comments

AshishChaudha 14-Aug-12 1:45am

[i need to display Product Name if front end if it is null values in db]...
I didnt understand what actually you want???

2 solutions

Add a Solution

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

Mehdi Gholam · Answer 1 · 2012-08-13T18:29:00

Solution 1

Use ISNULL : http://www.1keydata.com/sql/sql-isnull.html[^]

example :

SQL

select isnull([name],[description]) as [name] from [product]

Posted 13-Aug-12 18:29pm

Mehdi Gholam

AshishChaudha · Answer 2 · 2012-08-13T19:48:00

Solution 2

try this...If I correctly understands your problem..

SQL

select (case when Product_Name is null then product_description else Product_Name end) from Product

Thanks
Ashish

Posted 13-Aug-12 19:48pm

AshishChaudha

Updated 13-Aug-12 20:17pm

v2

Comments

Arul R Ece 14-Aug-12 2:09am

Hi Ashis,

The above query gives error,please check and update

AshishChaudha 14-Aug-12 2:40am

sorry..Updated my solution...

need help in sql query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

need help in sql query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us