Friday, February 22, 2019

[SQL] ISNUMERIC CAST REPLACE

    select isnumeric('abc')
    0
    select isnumeric (100)
    1

    select cast(23.495 as int)
    23

    select cast(replace('1234534!!!','!!!','') as int)
    1234534


No comments:

Post a Comment