RegEX in Director

[Thomas Biedorf]

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.

Any ideas?

Thanky you,
Thomas