Home Forums SQL Server 2005 T-SQL (SS2K5) Determine if String has numbers in datatype varchar(10) RE: Determine if String has numbers in datatype varchar(10)

  • March 9, 2009 at 8:27 am

    #956046

    Try

    update DimStudent

    set StudentZip = substring(StudentZip, 1, 5)

    where StudentZip like '[0-9][0-9][0-9][0-9][0-9]%'

    Madhivanan

    Failing to plan is Planning to fail