Re: LIKE comparison

From: Sultan <ssyed_at_fine.co.ae>
Date: Wed, 13 Sep 2000 09:13:16 +0400
Message-Id: <10617.116801@fatcity.com>

Hi,

May be you created column value in capital letter. This is case sensitive.
Check the value first ,your prob.will be solved.

Sultan.

> If I do a where os_user = 'xxoracle' I find the records I want.
> If I do a where os_user like '%oracle' I don't get any records.
> Can someone tell me why?
>
> Ron Smith
> Database Administration
> rlsmith_at_kmg.com
>
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
Received on Wed Sep 13 2000 - 00:13:16 CDT