Python/Gadfly and SQL wildcards

[Marc POINOT]

Gordon McMillan wrote:

> 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".
>

The GadFly doc says the "like" statement will not be
implemented. It says you have to use the Python strings
or RE facilities to do that.

Marcvs [alias The Gadfly doc is clear about what is SQL compilant or not
]