A small correction: if you want "Jo" to match John or LittleJohn, you need
to do:
SELECT * FROM customers WHERE name LIKE "%Jo%"
Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January
SELECT * FROM customers WHERE name LIKE "Jo%"
String comparisons are not case sensitive unless the comparison involves a
binary string.
Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, J
