Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Find integer at end of a string. There *must* be a better solution ? RE: Find integer at end of a string. There *must* be a better solution ?

  • July 25, 2013 at 8:06 am

    #1635725

    doh!, if it ends in [0-9] might be even easier?

    SELECT *,

    CASE

    WHEN x LIKE '%[0-9]'

    THEN 1

    ELSE -1

    END

    from tmp

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!