?
Solved

MS SQL 2005 - CONCATENATE Function?

Posted on 2007-04-05
2
Medium Priority
?
9,632 Views
Last Modified: 2012-08-13
I am trying to find a way to add some numbers to a column of data in MS SQL 2005. I am not sure if this is possible in MS SQL, but below is what I am trying to do -

UPDATE Table
SET column_name=CONCATENATE('00',column_name);

Any suggestions on how to do this are greatly appreciated.

Thank you
Kristofer
0
Comment
Question by:conquerdev
2 Comments
 
LVL 11

Accepted Solution

by:
dready earned 2000 total points
ID: 18861515
Is the column of type varchar() or char or text?
If so, it can be done this way:

update table set column_name = '00' + columnname

0
 

Author Comment

by:conquerdev
ID: 18861721
dready,

Worked Perfectly!

Thank you,
Kristofer
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
Viewers will learn how the fundamental information of how to create a table.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question