Contact: aviboots(AT)netvision.net.il
31,109 questions
40,780 answers
573 users
-- selects all workers that the their first name start with the letter "d" SELECT * FROM Workers WHERE FirstName LIKE 'd%'
-- selects all workers that the their first name end with the letter "f" SELECT * FROM Workers WHERE FirstName LIKE '%f'
-- selects all workers that the their first name contain "ie" SELECT * FROM Workers WHERE FirstName LIKE '%ie%'
-- selects all workers that the their first name NOT contain "ie" SELECT * FROM Workers WHERE FirstName NOT LIKE '%ie%'