Re: Collate

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sun, 2 Feb 2003 06:58:03 +1100
Message-ID: <GwV_9.38370$jM5.96509@newsfeeds.bigpond.com>

"Jasminder Rai" <jasrai_at_canada.com> wrote in message news:hgV_9.114485$Ui4.3247743_at_news1.telusplanet.net...
> 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'.

That specific example is a job for a function-based index.

Regards
HJR Received on Sat Feb 01 2003 - 13:58:03 CST