well, i'm having trouble using the inspect method.
I have a field in a record where the user can enter keywords, and later on it should be possible to retrieve the correct records using an inspect on that field.
fieldname is : KKKeys PIC X(25).
searchstring is : Find-word PIC X(10).
suppose i have 4 records like these:
SCORE WHY NOTHING
WHY NOTHING REGARDS
PLEASURE WITHIN WITHOUT
NOTHING HERE SCORE
Find-word = SCORE
Result = 1 (last record)
Find-word = WHY
Result = 0 (none found)
i guess the trouble is with spaces.
Is there an approach to get the 'perfect' results, or does one need to settle for a solution 'in the middle'?