update <table name> set column = '0' + ph no:

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

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

Answer Posted / goutham

update <table name>
set column = '0' + ph no:

Is This Answer Correct ?

3 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Call by value and call by reference in procedure and function, with NOCOPY.

1247

What is the full form of ddl?

866

Can group functions be mixed with non-group selection fields in ms sql server?

892

Who developed sql server?

877

What is the template in sql?

919

What is a cursor, index in sql?

1017

What is importing utility?

935

What is a livelock?

912

What is the significance of master, tempdb and model databases?

1026

How do I create a stored procedure in dbml?

928

How to send a ssrs report from ssis?

166

What does executeupdate return?

929

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1064

How to create a local temporary stored procedure?

949

Can we delete data from a view?

883