Stored Procedure to tidy up table

[Skc]

I have a table with fields that contain values with inverted commas - i.e.
"AAA" "BBB" etc... for field 1,2.

How do I create a stored procedure that goes through the whole table and
take out the inverted commas?

skc

[W.G. Ryan - MVP]

SKC:

I'm not sure I follow you. Is the actual column name in the table in the
first and second positions AAA and BBB respectively? Are the column names
what need changed or values in the table. If you would, just show me two
rows worth of data with the column name and then the values - and then
underneath it what it should look like i.e.

Column1 Column2 Column3
AAAA BBBBB CCCCC

or whatever. Also, what db are you using? I only ask b/c the syntax is
different in T-Sql vs. PL/SQL for instance. Finally, are you wanting to
take the data in the db and have it returned to a datatable in the new
format, or where you looking to do it client side with ADO.NET (or does it
matter as long as you ultimately get the result you want?)

If you can post this, I'll gladly do what I can to write the proc for you.
Ideally if you can post the schema for the table as well, I can use real
values and hopefully you'll be able to use the code I write.

Cheers,

Bill
"Skc" <Sk*@discussion s.microsoft.com > wrote in message
news:ED******** *************** ***********@mic rosoft.com...

I have a table with fields that contain values with inverted commas - i.e.
"AAA" "BBB" etc... for field 1,2.

How do I create a stored procedure that goes through the whole table and
take out the inverted commas?

skc