String Like Another - What Does It Mean ?


First of all, I have to say that in WORA context SQL limited notion of regular expressions ( maybe, they should be called wildcards, but I dont care :) is applicable only to the case when you are defining where clause and wanna match a string against some pattern. This patterns are considered here ( see explanations to WORA form ).
E.g.
	WHERE
		none
	of	 LAST_NAME	LIKE	Context: ___to_be_filled____
Pattern matching meta symbols, aka wildcards are
_
( underscore ), matches any character, but exactly one
%
( percent ), matches any number of any characters
So,
'lllll' like 'l__l%'
is TRUE
'absc' like '%'
is TRUE
'absc' like '_'
is FALSE
'1234' like '123'
is FALSE
and so on.
ocr