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.