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:28 am

    #956049

    It goes LIKE this:

    SELECT

    StudentZip,

    SUBSTRING(StudentZip, 1, 5) AS CleanedZip

    FROM DimStudents

    WHERE (StudentZip LIKE '[0-9][0-9][0-9][0-9][0-9]%')