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 6:11 pm

    #1635993

    Thorkil Johansen (7/25/2013)

    Someone said: Looks like 123.4 is not an integer, so -1 should be returned.

    Yes, that's right

    So if the string were xyz-1-2.3-2 what's the required answer?

    2, because -2 are the last two characters? or -1 because -1-2.3-2 isn't an integer?

    Tom