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
11478 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 a periodical index?

863

What is outer join in sql server joins?

1044

What is forward - only cursors / read only cursor?

1019

Explain SSRS Architecture?

179

How to implement service broker?

917

What is a scheduled job or what is a scheduled task?

910

What are the advantages of sql azure?

138

Does sql server 2016 have ssms?

910

What are Row versions of DataRow?

972

How to create a simple user defined function in ms sql server?

966

What is scd (slowly changing dimension)? : sql server analysis services, ssas

951

Can you get second highest salary from the table?

909

How do I edit a stored procedure in sql server?

879

How to achieve Paging of records in SQL SERVER?

1029

Is sql server implemented as a service or an application? : Sql server database administration

892