General discussion

  • Creator
    Topic
  • #2307293

    Modifying a field in a SQL Table

    Locked

    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!

All Comments

  • Author
    Replies
    • #3519499

      Modifying a field in a SQL Table

      by drinkin and thinkin ·

      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.

    • #3519463

      Modifying a field in a SQL Table

      by mail2krisk ·

      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

    • #3519461

      Modifying a field in a SQL Table

      by steve.simons ·

      In reply to Modifying a field in a SQL Table

      This question was closed by the author

Viewing 2 reply threads