CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Aryan
Aryan

Reputation: 104

Replace data in a column for a character in SQL

I have a table having data like as below:

  Description   Name
    ABC           AB
    ABCD          AB, BC, CD
    ABCDF         AB, BC

Now i needed output as below:

  Description   Name
    ABC           AB
    ABCD          AB, BC and CD
    ABCDF         AB and BC

How can i get desired output in SQL? please help me out.

Upvotes: 3

Views: 78

Answers (2)

TechDo
TechDo

Reputation: 18629

Please try:

select 
    Description, 
    ISNULL(
       REVERSE(STUFF(REVERSE(Name), CHARINDEX(',', REVERSE(Name), 0),1,'dna ')), 
    Name) Name
From YourTable

SQL Fiddle Demo

Upvotes: 1

Lali
Lali

Reputation: 2866

Do it as

declare @str nvarchar(200)
set @str = 'Ali, ahmed, riaz, zoya'
select SUBSTRING(@str, 0, (len(@str) - charindex(',', reverse(@str)))) +
Replace(SUBSTRING(@str, (len(@str) - charindex(',', reverse(@str))), len(@str)), 
', ', ' and ')

Upvotes: 1

Related Questions