update <table_name> set phno = Convert(int, '0' + Convert(

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 / a

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

Answer Posted / a

update <table_name> set phno = Convert(int, '0' +
Convert(varchar(10),phno))

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a field name?

1017

Explain alternate key, candidate key and composite key in sql server?

946

what is a self join? Explain it with an example? : Sql server database administration

1002

What are exact numeric data types in ms sql server?

1138

What is the query and subquery?

1119

What is table-valued sub query?

1026

How to run queries with sql server management studio express?

1152

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

958

How do I view views in sql server?

1058

What is difference between sql and sql server?

1079

What are transactions in sql?

1128

How to select some specific columns from a table in a query in ms sql server?

1044

What is scan table/view and seek table/view when its occurs? : sql server database administration

1088

How use inner join in sql server?

1186

List the different index configurations possible for a table?

977