SQL Guide : solidDB® SQL statements : Common clauses : Wildcard characters
  
Wildcard characters
The following may 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 also
Common clauses