Add 2 for all phone numbers

[sravanvellala]

I want a query for the the phone number in the database are like this 47407 and i want add 2 for the all the phone nubmers. it is clear i think i want add one number.

[debasisdas]

Do u wan to add 2 or concadinate 2 to the existing value ?

What is the data type of the phone number field in the table ?

[bhavanakalia]

select to_char('2'||phone) from ;

[sutnarcha]

I think "sravanvellala" wants to a digit ‘2’ is to be suffixed to the numbers.

Use this command… to update all rows of the table.

If it is a text field…
UPDATE SET = ‘2’ &

If it is a numeric field…
UPDATE SET = + 2 * (100000)

This is for a 5 digit phone number like in ur example 47407.
I will have to come back to this thread with a generic query for a numeric field.