Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Modifying a field in a SQL Table

Locked

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!

Topic

Modifying a field in a SQL Table

In reply to Modifying a field in a SQL Table

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.

Modifying a field in a SQL Table

In reply to Modifying a field in a SQL Table

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

Modifying a field in a SQL Table

In reply to Modifying a field in a SQL Table

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

Modifying a field in a SQL Table

In reply to Modifying a field in a SQL Table

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

Thanks!

Modifying a field in a SQL Table

In reply to Modifying a field in a SQL Table

This question was closed by the author

[Author]

Replies