Oracle is always case-sensitive. Others may vary ... HTH, Kevin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:25 PM To: [EMAIL PROTECTED] Subject: SQL-List V1 #35 ---------------------------------------------------------------------- Date: Thu, 30 Aug 2001 13:28:53 -0500 From: "Bernd VanSkiver" <[EMAIL PROTECTED]> Subject: case sensitive Message-ID: <000d01c13181$9f70da40$[EMAIL PROTECTED]> What is the syntax on doing a case sensitive SELECT query? SELECT ColumnName FROM tableName WHERE ColumnName = 'Test Query' Want this to do a case sensitive search on the WHERE clause. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------ End of SQL-List V1 #35 ********************** Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
