solidDB Help : solidDB reference : SQL: Statements : Wildcard characters
  
Wildcard characters
The following characters can be used as wildcard characters in certain expressions, such as LIKE 'string'.
 
Character
Explanation
_ (underscore)
The underscore character matches any single character. For example, 'J_NE' matches 'JANE' and 'JUNE'.
% (percent sign)
The percent sign character matches any group of 0 or more characters. For example:
'ED%' matches 'EDWARD' and 'EDITOR'
'%ED%' matches 'EDWARD', 'TEDDY', and 'FRED'.
See
Using SQL wildcards
Wildcard characters as literals
Go up to
SQL: Statements