Home Forums SQL Server 2008 T-SQL (SS2K8) Remove the first two characters in a column value if they meet a certain condition RE: Remove the first two characters in a column value if they meet a certain condition

  • December 20, 2012 at 9:55 pm

    #1570712

    Please check this...

    update <table name> set name = SUBSTRING (name,3,len(<column name>)) where SUBSTRING(<column name>,1,2)='NA'