wildcard characters in SQL Server

Tag: A uses SQL Server SQL Server

_,%, [], ^

1, ^ only MSSQL server support, other DBMS with not like.

2, wildcard% multi-character matching wildcard character, it matches any number of times (0 or more) occurrences of any character

3, Wildcard _ single-character match, it matches the individual occurrences of the character

4, [] match only one character and the character must be [] within the range [0-9] [A-z]

Not used with like: not as ....

What to do with _,%, [, ^]?

[_], [%], [[], ^ (do not need to be placed in brackets, because ^ is only placed in brackets to be considered a wildcard character), you can assume that [] is an escape function.