• ^ is the negation. So %[^0-9.-]% means "every character that is not 0 through 9, a dot or the minus symbol".

    LIKE (Transact-SQL)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP