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'. As another example, '%ED%' matches 'EDWARD', 'TEDDY', and 'FRED'.