SQL SELECT queries ARE case sensitive.
The problem is in your data -- you're using columnames
from your tables as data. Depending on the database,
this information is stored in auxiliary tables (in
Oracle, it would be in a table like
"all_tab_columns"), and may be in a case-insensitive
form. For example, in Oracle, if I run
select column_name, table_name from all_tab_columns
then I see that all the column_names and table_names
are all uppercase even though when I created the
tables, I had mixed case for the table and column
names
--- Bernd VanSkiver <[EMAIL PROTECTED]> wrote:
> Is there a way to do a case sensitive SELECT query?
> Don't want to make a
> server wide change, just want to specify a single
> query to do a case
> sensitive search.
>
> 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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
