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
11784 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 minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1039

What is the purpose of the model database?

1009

How to create function without parameter in sql server?

1047

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

908

How can we call UDF(User Define Function) using C# code in ASP.net ?

6871

What do we need queues in sql service broker?

1061

What is BLOCK statements in SQL?

1257

What is built-in/administrator?

996

How raid can influence database performance?

1020

What is a field name?

955

What are temporal tables in sql server 2016?

875

How can I create a new template for import ? : sql server management studio

1065

What is primary key index?

973

What is the largest component inside a field?

1112

How to select an exiting database using mssql_select_db()?

979