girlswants_me
asked on
query problem
Using Query in Ttable
how can i get ALL records having:
*Partial Match at the beginning
*Exact Match
*Partial Match anywhere
and
*case sensitive or not case sensitive.
Example.
how can i get all records with using
(thefield >= 'Ant%') and (thefield <= 'Cat%')
when should i use "Like" and the logical operators like
"=",">=","<>"....?
how can i get ALL records having:
*Partial Match at the beginning
*Exact Match
*Partial Match anywhere
and
*case sensitive or not case sensitive.
Example.
how can i get all records with using
(thefield >= 'Ant%') and (thefield <= 'Cat%')
when should i use "Like" and the logical operators like
"=",">=","<>"....?
use the % delimiter. Example select * from users where lastname like '%mit%' would return smith,mithos,smithers. Remove either the first or trailing % sign to eliminate partial matches in front of or behind.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no codes
what codes?