[Gambas-user] Wild cards in filter expressions

[Marty McGlensey]

Hello,

 

I need to write a filter expression for a datasource that includes wildcard
characters (* or ?).  I'd like to filter on this expression name = '*mith'.
The result should be all records with a name equal to Smith. I'm using MySql
as the underlying database. The usual wildcards are the * and ?. In MySql I
have found it to be %.

 

Does Gambas support wildcards in filter strings? If so, what are they? Is
there a work around?

 

Thanks,

Marty