Re: search over database

From: <tedchyn_at_yahoo.com>
Date: Sat, 28 Oct 2000 06:06:52 GMT
Message-ID: <8tdqdq$2kr$1@nnrp1.deja.com>

you may convert the all string to uppercase using upper function and do the comparison from there.
ted chyn
In article <8tbut6$h3r$1_at_nnrp1.deja.com>, thorsten2103_at_my-deja.com wrote:
> hello,
>
> it's possible to search over all fields on every table
> for a word or number (like a Meta-Search) within one database ?
> the problem is that we use big and small letters in the
> fields.
> We use Oracle8.0.5 on NT.
>
> Please Help. Thanks.
>
> Thorsten
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 28 2000 - 01:06:52 CDT