Python/Gadfly and SQL wildcards

[ScherBi at BAM.com]

AFAIK, the ANSI SQL wildcard for multiple characters is % (percent sign),
and for a single character is _ (underscore).  These would equate to * and ?
in DOS land...

Bill

-----Original Message-----
From: Colm Rafferty [mailto:c.rafferty at formulae.co.uk]
Sent: Monday, July 19, 1999 3:48 AM
To: python-list at python.org
Subject: Python/Gadfly and SQL wildcards


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

-- 
http://www.python.org/mailman/listinfo/python-list