While using SQL pattern matching, what is the difference between '_' (underscore) and '%' wildcard symbols ?
In SQL pattern matching, the underscore ('_') character matches any character, while the percent ('%') wildcard character matches any substring.