I presently work in the banking industry and I am putting together a report where one of the fields in our DB is a "comment" field. The tellers enter comments about the customers such as "bill payer active" or "spouse deceased", etc.

A customer may have several of these fields under his customer number to encompass all of the comments. For example a CR with the comment field may look something like this:

Bill Smith     0112233            This customer presently
Bill Smith     0112233            has a debit card and his
Bill Smith     0112233            car loan .... etc.

My question is this. Is there a way to find a string within these fields and display those records? Using the above example, a search on "debit card" should return the second record. I tried several different things but I've only been successful at returning entire fields. If anyone can offer any input it will be greatly appreciated.

-- Crystal Newbie