Web Development

Ask something
Discussion Locked

Modifying a field in a SQL Table

0 helpful
5 replies

by steve.simons 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

If I have a field in a table that has

"456789 ---Field Name (XYSKU)

How would I modify that entry to remove the quotation mark and keep the numbers? I would want this to update all entries in the associated field because all entries are preceded with (").

I have the same problem with another field that has the quotation mark at the end of the data

000000765.00" --Field Name (COST)

Thanks in advance!

5 replies

by drinkin and thinkin

You could put together a little web app using PHP or ASP that would query the DB, replace the quotation marks and then do a replace on the data. I've done similar tasks that way.

You'll also need to fix the code that allows the quotation marks to be entered into the DB in the first place or else it'll be a recurring problem.

by mail2krisk

hai.
as u havn't mentioned whether the table belong to oracle/any other stuff.There is an sql function REPLACE. U can use it to solve. U have to create a new table with quot.mark cleared data then drop the orignal table and then recreate the orignal table with the create table as select sql. i can give u a small sample to create the new table without quot.mark. CREATE TABLE AS SELECT REPLACE (COST,'"','') COST FROM

This discussion is closed to new replies.