Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Like condition or alternative

tbhluehornOct 2 2019 — edited Oct 8 2019

Good day friends,

I would like some help finding an alternative to the like condition, in a select statement.

    class not like   ('%21%')

or    class  like   ('%22%')

or    class  like   ('%28%')

or    class  like   ('%44%')

or    class  like   ('%56%')

or    class  like   ('%57%')

or    class  like   ('%65%')

or    class  like   ('%76%')

or    class  like   ('%80%')

or    class  like   ('%84%')

or    class  like   ('%90%'))

I am trying to exclude all records with these numbers in a field which contain data as follows.

Class

<21 Classof2007/GPA (3.7) >< 84 W+H HSD (Sys)>

Thanks in advance , God bless.

This post has been answered by BluShadow on Oct 2 2019
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2019
Added on Oct 2 2019
11 comments
1,153 views