Concatenating String in SQL Server 2005

Question

Does anyone know how I would go about concatenating a string in SQL Server 2005.

What I mean is something like the following scenario.

I have a nvarchar(MAX) column in a SQL Server 2005 database.

Lets say the column has a value of "A" and I want to add "B" making "AB", what is the simplest way to go about this. Will I need to do a Select, concatenate the two values in code and then update the column? Or is there a more nifty way to do this?

Any pointers much appreciated.

FlySwat · Accepted Answer · 2009-12-04 05:54:57Z

8

In T-SQL:

     UPDATE table SET col = col + 'B' WHERE (PREDICATE THAT IDENTIFIES ROW)

If you were using Oracle it would be:

     UPDATE table SET col = col || 'B' WHERE (PREDICATE THAT IDENTIFIES ROW)

answered Dec 4, 2009 at 5:54

FlySwat

176k75 gold badges249 silver badges314 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Adriaan Stander Over a year ago

T-SQL is what th OP wanted, see the tags.

FlySwat Over a year ago

Oracles pipe operators are unique enough that it was worth mentioning for other people who search for this.

Adriaan Stander · Accepted Answer · 2009-12-04 05:41:39Z

2

You can do something like this

DECLARE @Table TABLE(
        Col VARCHAR(MAX)
)

INSERT INTO @Table (Col) SELECT 'A'

SELECT  Col + 'B'
FROM    @Table

UPDATE @Table
SET Col = Col + 'B'

SELECT * FROM @Table

answered Dec 4, 2009 at 5:41

Adriaan Stander

167k32 gold badges294 silver badges288 bronze badges

Collectives™ on Stack Overflow

Concatenating String in SQL Server 2005

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related