update <tablename> set phno=cast (0 as datatype(1))+phno

I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz...

Question Posted / rajshekar

7 Answers
11832 Views
Value Labs, I also Faced
E-Mail Answers

Answer Posted / rajshekar

update <tablename>
set phno=cast (0 as datatype(1))+phno

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of commit?

1001

Explain user defined functions?

995

How many types of objects are there?

1009

Does full backup break log chain?

963

What types of replication are supported in sql server?

1063

What do you need to connect php to sql server?

1104

What is fill factor and pad index?

1014

explain declarative management framework (dmf) in sql server 2008?

995

What are the differences between having and where clause.

966

Explain the usage of floor function in sql server.

965

What do you do in data exploration

993

What is the dbcc command and why is it used?

1052

how to overcome kernel isssues

1626

Explain time data type in sal server 2008?

924

Explain about SQL server 2005?

979