> Hi all,
> I'am trying to retrieve records with wildcards using:
> m_pSet->m_strFilter = "Name = 'N*'";
> All I get is an empty record. The filter works only if I pass in the
> whole name (e.g m_pSet->m_strFilter = "Name = 'Nicholson'";) but this is
> not what I want. Since filters work like MS Access SQL why can't I use
> the " * " wildcard???? Is there anyone out there who can help me
> Thank you in advance.
> Alberto Gattegno
> Nulan Technologies Ltd.
> Ha'Arad 7. Ramat Ha'Hayal.
> Tel Aviv Israel.
use the SQL LIKE operator!
m_pSet->m_strFilter = "Name LIKE 'N%'";
-> % matches any string of zero or more characters
-> _ wildcard for a single character
Address is altered to discourage junk mail.
Remove ".---" for the real address.