ADO Hierarchical Recordsets

[VBMental]

When using the SHAPE provider, are you allowed to use LIKE operator in thee WHERE segment of the SQL phrase?

Example:
SHAPE {SELECT * FROM tblCustomers WHERE fName LIKE '*ackson*'}


When I use the LIKE expression, the recordset seems to return all or no records as if the LIKE expression doesn't work.

Thanks in advance

 

[CamyB]

Try to use %, no *.

Example:

 SHAPE {SELECT * FROM tblCustomers WHERE fName LIKE '%ckson%'}

Good luck! ;-)
Camy.