LIKE

The LIKE condition is used to specify a search pattern in a table column.

SELECT column FROM table WHERE column LIKE pattern

pattern :: '[% | _ | [] | [^] | character]'

The percent (%) is the wild card specifying zero or more characters of any values.

The case appears to be ignored.

The '[' is used as an escape character for special characters.

To find a string with a '[' in it you would used the following %[[]% pattern.



See LIKE (Transcat-SQL)