Post reply

UPDATE, there has got to be an easy way

  • December 18, 2003 at 7:04 pm

    #160312

    I have a table imported from a UNIX box, 2 of the columns contain a double quote as the last character, never in the same position.

    Does anyone know an easy to get rid of that double quote.

    I am pretty new to SQL, so don't laugh if the answer is a simple one

  • December 18, 2003 at 7:13 pm

    #487131

    Try

    

    UPDATE foo

    SET Field = REPLACE(Field, '"','')

    Gary Johnson

    Microsoft Natural Language Group

    DBA, Sr. DB Engineer




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply