Search mechanisms

The wild-card key is "*", i.e. "part*" would show anything with part or
parts in it...
On SQL based apps I have used before, I could preceed the search
string by typing an percent-sign (%) and this would allow the search
to pull records where the selection criteria was contained in the
recordset.

Is there anyway to do this since I am running vantage 808e2 on
Progress? If so, would this be passed correctly from the Vantage app
to the database?
I am trying to get over the issue where searching for "part"
and "parts" return different values because the search appears to be
word based versus character based.....even in the field marked "where
description contains".

Thanks
Carey