Post reply

Update statment

  • February 26, 2009 at 10:05 am

    #95097

    I need to Update Address to (PO Box) field where I find Post Office Box in that field (like Post Office Box%) and I don't know how to do it.

    Example of the data:

    Post Office Box 225 need to be equal to PO Box 225

    My start:

    UPDATE TblCust

    SET

    tblCust.A1 =

    ????????

    FROM

    TblCust

    where

    (A1 LIKE 'POST OFFICE BOX%' OR

    A1 LIKE 'POST OFFICE BOX%')

    Thank you

  • February 26, 2009 at 10:13 am

    #950708

    Look up the function REPLACE in Books Online

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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