Doyle:
- DISTINCT is necessary ?
- Donnot use $, it can fire errors on Select
- use this

WHERE ATC('&myVal',name)>0 && if myVal is a variable, for 180K macro is faster

Any index is useless because $ , LIKE '%..' , LIKE() , AT , ATC are not optimizable.