RegEX in Director

[Hans-Joerg Bibiko]

Thomas


 >>I want a SQL-search in Director which finds exactly one word.
 >>
 >>In the Docs I found:
 >>
 >>"SELECT returnField FROM Tablename WHERE textfield LIKE '\AmySearchText\Z' no_case"

don't confuse \A, \Z with \b!

\A means the WHOLE field begins with
\Z means the WHOLE field ends with

\b means word boundaries like SPACES, KOMMATA, BRACKETS, etc.

"one two three" starts with 'o' (\A) and ends with 'e' (\Z\.

Hans