Hi ,



I have to filter the records based upon the last word of a field. I am doing the following


Code:
 rec.Filter = "Category like *Instructions"
This is giving me an error.

However, the following line works


Code:
 rec.Filter = "Category like *Instructions*"
But the problem is it returns me records even if the word Instruction is in the middle or somewhere else in the string. Is there any way to get me the required result.



Thanks