471,075 Members | 1,252 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Append a string to all the values in a column SQL

Sub: Append a string to all the values in a column SQL
Hi all,

This might be a very simple query. But I am new to SQL programming.
Hope someone can help me.

I have a table ---

1634 Fred los angeles
123 Sam
1245 abc
1231 ....
1278 .....
578 ....

I want to append TD before the numbers in the first column, I know
there should be a simple statement for this. But I am not getting it as
I have done SQL.
I would like to get

TD1634 Fred los angeles
TD123 Sam
TD1245 abc
TD1231 ....
TD1278 .....
TD578 ....

Hope someone can help me.

Thanks.

Jan 13 '06 #1
0 894

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by waters | last post: by
3 posts views Thread by RiGGa | last post: by
6 posts views Thread by allyn44 | last post: by
6 posts views Thread by deejayquai | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.