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
11798 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

How can i Relate Tables in SSIS

1077

How to Update from select query in sql server?

1058

Which is better statement or preparedstatement?

922

How to use wildcard characters in like operations in ms sql server?

1134

Is it possible to update the views? If yes, how, if not, why?

1023

What is a livelock?

954

What are diverse clauses that form a part of sql?

1065

How will you find out if there are expensive SQL statements running or not?

1010

how to invoke a trigger on demand? : Sql server database administration

1080

What are the different types of replication are there in sql server 2000?

1036

What is importing utility?

981

Explain what is “asynchronous” communication in sql server service broker?

914

How to create user defined functions with parameters?

1222

What are the tool windows in sql server management studio? : sql server management studio

1071

How do I find the default sql server instance?

938