Well, it depends on the RDBMS. Some are set up to be case sensitive,
others are not. If its not set up to check case, then I don't know any way
to do it.
-dhs
At 01:28 PM 8/30/01 -0500, you wrote:
>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
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists