SQL正则表达式，用于检查字符串是否包含某个子字符串

I am using SQL and need to check if a string contains a certain substring using regular expressions. Lower and upper case letters and space are allowed. I am using SQL and need to check if a string co