Web Development

General discussion

Gravatar
0 Votes
Locked

Modifying a field in a SQL Table

By Steve.Simons ·
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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Modifying a field in a SQL Table

by drinkin and thinkin In reply to Modifying a field in a SQ ...

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.

gravatar
Collapse -

Modifying a field in a SQL Table

by Steve.Simons In reply to Modifying a field in a SQ ...

I understand that the car is broke. I was asking for a fix.

gravatar
Collapse -

Modifying a field in a SQL Table

by mail2krisk In reply to Modifying a field in a SQ ...

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 <Dest.Table> AS SELECT REPLACE (COST,'"','') COST FROM <source table>

gravatar
Collapse -

Modifying a field in a SQL Table

by Steve.Simons In reply to Modifying a field in a SQ ...

Maybe my question WAS a bit vague. Sorry. Fortunately, I think you nailed it!

Thanks!

gravatar
Collapse -

Modifying a field in a SQL Table

by Steve.Simons In reply to Modifying a field in a SQ ...

This question was closed by the author

Back to Web Development Forum

Start or search

Related Discussions

Related Forums