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.
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.
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 ?
select to_char('2'||phone) from;
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…
UPDATESET = ‘2’ &
If it is a numeric field…
UPDATESET = + 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.
Last edited by sutnarcha; 10-01-2007 at 02:53 AM.
Lack of WILL POWER has caused more failure than
lack of INTELLIGENCE or ABILITY.
-sutnarcha-