See if SOUNDEX() and difference() functions help. Like:

SELECT * FROM MyTable WHERE soundex(cName) = soundex(lcSearchFor)



>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?