Home Forums SQL Server 2008 SQL Server Newbies UPDATE PART OF DATA RE: UPDATE PART OF DATA

  • March 10, 2013 at 7:22 pm

    #1595361

    SELECT

    COMCOD

    ,STUFF(SIRCODE,1,2,'19') AS SIRCODE

    ,SIRDESC

    FROM

    [YourTable]

    WHERE

    LEFT(SIRCODE,2) = '18'