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
11810 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 the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1045

Does sql server 2000 full-text search support clustering?

860

How to backup SQL Server Reporting Services ?

148

How do I delete a sql server database?

1041

What is full outer join in sql server joins?

1066

What do you mean by cardinality?

901

Explain what is the difference between union and union all?

1007

What are scalar functions in sql?

1142

What is query parameter in ssrs?

160

What is normalization and what are the advantages of it?

983

How to create a dml trigger using create trigger statements?

1029

Explain about Views?

1063

How many categories of data types used by sql server?

1010

How to concatenate two character strings together?

1114

What is triggers in ms sql server?

1115