> Apparently CAST was introduced into MySQL 4.0.2 - unfortunately my > webhost is using 3.23.58. > I'd like to know if this works or not. Can anyone test this method and > report back? then the separtate numeric index is probably your best bet. Lathrop