SQL query to concatenate column using Case statement in SQL Server

rakibxl

SOLVED CLOSED ACTIVE ANSWERED
User: rakibxl
Posted: on Sep 10, 2018 11:39 PM
Forum: SQL Server
Answer: 1
Views: 1809

i want to show a value from database like rakib(SAP) consider rakib = name and SAP = Code.if that name does not have code then i want to show only rakib not the bracket.How can i do using sql server query any idea?

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 4

Reply
ANSWER
User: pandeyism
Replied: on Sep 11, 2018 01:23 AM
Modified: on Sep 11, 2018 01:24 AM
Report

Hi rakibxl,

Please refer below Query.

SQL

DECLARE @TESTDEMO AS TABLE(Name VARCHAR(20), Code VARCHAR(20))
INSERT INTO @TESTDEMO VALUES('rakib','12')
INSERT INTO @TESTDEMO VALUES('Jack Ryan','34')
INSERT INTO @TESTDEMO VALUES('akabar',NULL)
INSERT INTO @TESTDEMO VALUES('suleiman','')

SELECT	CASE WHEN NOT ISNULL(Code,'') = '' THEN Name + '(' + Code + ')' 
		ELSE Name END NameCode
		FROM @TESTDEMO

Output

NameCode

rakib(12)

Jack Ryan(34)

akabar

suleiman

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

SQL query to concatenate column using Case statement in SQL Server

Company

Explore

Follow us

Contact Us