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
11494 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 store procedure?

1009

Explain time data type in sal server 2008?

872

How to download and install microsoft sql server management studio express?

976

How do you run a trace?

849

Do you know what guidelines should be followed to help minimize deadlocks?

922

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

839

What is difference between createstatement and preparedstatement?

1022

List the data types available in mssql?

959

How do you Implement SSIS Packages in your Project?

1872

How do you check sql server is up and running?

935

Does partitioning help performance?

891

Explain the difference between functions and stored procedures in sql server?

921

What is a sql join?

954

What is a derived table?

872

How to manipulate data from one table to another table ?

913