Using Query in Ttable
how can i get ALL records having:
*Partial Match at the beginning
*Partial Match anywhere
*case sensitive or not case sensitive.
how can i get all records with using
(thefield >= 'Ant%') and (thefield <= 'Cat%')
when should i use "Like" and the logical operators like