Hello,

I am working on a query which results in matches that contain similar strings as the search string. Especially double characters should be taken into consideration:

For example:
lcSearchFor = "GAMMA"
SELECT * FROM MyTable WHERE cName = lcName

Should result into:

GAMA
GAMMA
GAAMA
etc.

Has anybody an idea how to do this in a more or less simple way?