DB2 insert query.

saubhik · New User Joined: 21 Sep 2007 Posts: 17 Location: kolkata

Suppose i have a table which has a 4 digit column called Telephone number(for eg 1234,1111,etc).If i want to add 9 infront of the number.How can we do it thru a SQl query.Like after the execution of the query the telephone number will be like(91234,91111).

Craq Giegerich · Posted: Wed Jul 23, 2008 10:34 pm Post subject:

If its a 4 digit column then it can't contain an 8 digit value so you wouldn't be able to insert a '9' anyways. What is the definition of this column?

saubhik · New User Joined: 21 Sep 2007 Posts: 17 Location: kolkata

suppose you have changed the column definition so that it can accomodate 5 digit number.Then also how can we insert 9 before that 4 digit number.

Robert Sample · Posted: Wed Jul 23, 2008 10:53 pm Post subject:

I'm no DB2 expert, but can't you do something like

saubhik · New User Joined: 21 Sep 2007 Posts: 17 Location: kolkata

Thanks man!!i think it will work.

murmohk1 · Posted: Thu Jul 24, 2008 8:32 am Post subject:

Saubhik,

vasanthkumarhb · Posted: Thu Jul 24, 2008 11:54 am Post subject:

Murali,

It should work!!!

dbzTHEdinosauer · Posted: Thu Jul 24, 2008 12:11 pm Post subject:

if telephone no is char (or varchar), it will not work.

but then we do not know the datatype of the column in question.