Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
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)
Home > Flashcards > Print Preview