Re: Collate

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sat, 01 Feb 2003 19:46:09 GMT
Message-ID: <BA616400.8750%markbtownsend@attbi.com>

in article hgV_9.114485$Ui4.3247743_at_news1.telusplanet.net, Jasminder Rai at jasrai_at_canada.com wrote on 2/1/03 11:31 AM:

> Thanks for the reply. To answer your question about how I want to use it.
> I want to be able to search in a where clause for example.
> where source = 'tf000098'
>
> and the server does a case-insensitive search and returns those rows that
> are stored in the database as 'TF000098' or 'tf000098'.

In that case, you will need to use the UPPER function in the query, and possibly create a functional index on UPPER(column) Received on Sat Feb 01 2003 - 13:46:09 CST