Hi,

I don't find mention of "LIKE" in the the SQL documentation that comes
with Pervasive, but from some of the postings here it looks like maybe
you can use it -- I have 2000i SP3. What's the definitive answer, and
if you can use it in a query, what do you use for a multiple-character
wildcard?

Thanks.

Yes. Use % for multi-char, _ for single-char.
e.g. Select * From Person Where LastName LIKE 'B%'

Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: August, 2004: See our web site for details!


Robin wrote: