Nice article and primer for string searching.  For the decimal test, you could also use the try_parse to find records that can be converted to decimals.   SELECT * FROM...