Python/Gadfly and SQL wildcards

[Gordon McMillan]

Colm Rafferty writes:

> 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

In ANSI SQL, that would be "fieldname like 'A%'"

Last I used Gadfly, it didn't support 'like', so you're stuck with

..fieldname >= 'A' and fieldname < 'B'

or the same using "between".

- Gordon