Card Set Information
<> or !=
Firstname of Lisa or david
where firstname = 'lisa' or firstname = 'david'
where firstname IN ('lisa','david')
Find all that start with letter d
where FirstName like 'd%' ( Anything starting with d)
where Firstname like '%d' ( Antything ending with d)
where FirstName like '_a%' (Antything with A in second)
Find all that start with a or b
where FirstName like 'a%'
or FirstName like 'b%'
Find all that start a though k
where FirstName like '[a-k]%' (Sting is in ' ' can use _)
Find amounts between certain numbers
where Amount between 21000 and 30000
Find special characters in a name such as % or _
where GrantName like '%[%]%' (in the  you put in the character)