Hi there
Ok so the obvious way to search on a term in freefrom text records might look something _like_:
SELECT fldDate, fldQuestion, fldAnswer
FROM tblQuestion
WHERE fldQuestion LIKE '*[txtKeyword.text]*'
But what exactly does that return, if I search for the term 'AT' I'll also get 'cat', 'sat', 'match', 'At the ...' etc.
All of the case sensitive keyword threads I've seen so far seem to concentrate on searching for the entire keyword using functions in a module headed OPTION COMPARE BINARY. This seems fair but I don't see how to apply (and further filter using such a function) what is returned by the base LIKE clause from the SQL.
I would be grateful to correspond with anyone else who has dealt with something like this?
Many thanks for reading/answering.
blue skies
j.
Ok so the obvious way to search on a term in freefrom text records might look something _like_:
SELECT fldDate, fldQuestion, fldAnswer
FROM tblQuestion
WHERE fldQuestion LIKE '*[txtKeyword.text]*'
But what exactly does that return, if I search for the term 'AT' I'll also get 'cat', 'sat', 'match', 'At the ...' etc.
All of the case sensitive keyword threads I've seen so far seem to concentrate on searching for the entire keyword using functions in a module headed OPTION COMPARE BINARY. This seems fair but I don't see how to apply (and further filter using such a function) what is returned by the base LIKE clause from the SQL.
I would be grateful to correspond with anyone else who has dealt with something like this?
Many thanks for reading/answering.
blue skies
j.