Python/Gadfly and SQL wildcards

[Colm Rafferty]

Dear all,
I'm new to list.
I'm looking at gadfly to use SQL with python.
Does anyone know how to implement the wildcard in gadfly SQL?
e.g.
Select * from table where fieldname = 'A*'
or
Select * from table where fieldname like 'A*'

* does not work!
Though it does in other SQL languages

Thanks for any help

Colm Rafferty