Flashcard.txt

Not Equal

<> 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)

Author

Anonymous

190696

Card Set

Flashcard.txt

Description

Select Statement

Updated

2012-12-27T20:40:12Z

Show Answers