RegEX in Director

[Hans-Joerg Bibiko]

Dear 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"
> 
> But it doesn't work. An Example:
> 
> textfield contains "one two three" and I want to find "two".
> My SQL reads like this:
> 
> "SELECT returnField FROM Tablename WHERE textfield LIKE '\Atwo\Z' no_case"
> 
> GetRecordCount() returns 0.
> 

The ankers \A means begin of a string and \Z means the end of a string.
So you only find values where TEXTFIELD = 'two'!!

You have to write
"SELECT returnField FROM Tablename WHERE textfield LIKE 'two' no_case"

Hans