Inserting a character in the beginning of a string in SQL

Question

I need to change all the 'PostalCode' column strings by setting a character 'A' at the beginning of the string. I've tried this:

UPDATE Customers SET PostalCode = STUFF(PostalCode , 0 , 1 , 'A')

But nothing... Any ideas?

Rahul Tripathi · Accepted Answer · 2016-07-28 12:01:50Z

6

You can try to use CONCAT

UPDATE Customers
SET PostalCode = CONCAT('A', PostalCode )

answered Jul 28, 2016 at 12:01

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

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

1 Comment

Why not A + PostalCode?

M. Jamshaid Alam · Accepted Answer · 2016-07-28 12:24:28Z

1

You can try this, I hope this is useful for you.

UPDATE Customers
SET PostalCode = 'A' + PostalCode

answered Jul 28, 2016 at 12:24

M. Jamshaid Alam

869 bronze badges