This covers the kinda odd situation of running asp/vbScript pages from a mySQL database instead of SQL or Access. The syntax for limiting the number of records needs to be manually edited, since you can't do "TOP" in mySQL. This works for my case:

Sql = Sql & sPrimary & sOptional & " FROM " & sTable & " WHERE " & sLike & "LIMIT "& nLimit

Hello Alice,

I will pass your suggestion to our developers