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