exact queries of memos - 09-12-2003 , 01:08 PM
I've searched the knowledgebase and the newsgroup for a possible
solution to this, but to no avail…
I want to create a query against a memo column for a specific value.
E.g. FIELDNAME = "ABC"
With a string field, I pad the expression to the field size, but this
approach does not work with memos since there is no fixed field size.
So, just leaving the expression as is, I get back "ABC" along with
everything else that starts with "ABC". How can I write a query that
would give me back just records where FIELDNAME = "ABC"? To me, what's
really missing is a LEN() expression for memo fields, so I could go
(FIELDNAME = "ABC") .AND. (LEN(FIELDNAME) = 3)