Re: use command set sqlcase upper from within VB 6.0 app ?

Why can't you use 'and upper( field ) = 'THIS' in your query?

<cgrandy_at_disc.com> wrote in message news:956p35$7rr$1_at_nnrp1.deja.com...
> OMNIDEX can enhance Oracle to give you case-insensitive searches. See
> http://www.disc.com/keyword.html or contact me.
>
> Cheryl Grandy
> cgrandy_at_disc.com
>
> In article <eido6t0khgog05bcijrlgevk01lgmtqa46_at_4ax.com>,
> Bernd Rosenau <brosenau_at_gss-online.de> wrote:
> > Hi,
> >
> > our VB 6 application uses ADO to access tables on a Oracle 8 server.
> > Our clients are asking for case insensitive searching.
> >
> > I found out that one can switch this feature on with the command SET
> > SQLCASE UPPER but this seems only to work within SQL PLUS.
> >
> > Is there a way to make the setting SQLCASE UPPER valid for the whole
> > Oracle server and therefore for my VB 6 program or is there a way to
> > set SQLCASE to upper by using ADO ?
> >
> > Many thanks in advance
> >
> > Cheers Bernd
> >
> >
>
> --
> Cheryl Grandy
> DISC
> Get OMNIDEX for the fastest
> applications ever
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Feb 06 2001 - 07:33:37 CST