Query which extracts field with certain embedded characters

[Neeraj]

I want to extract records having a certain sequence of
characters (3-4 characters in length) eg. the
chracters 'abc' might be embedded in a particulat field,
so I may extract only those records which have 'abc'
anywhere in the field. How can I phrase such a select
statement.

Thanks

Neeraj