[Zope] left(string, n) equivalent (newbie q.)

[joel grimes]

Pardon my ignorance, I'm coming from a VB/Access background.

I need to find an equivalent to using left(string, 4) in a zope SQL method's 
select query.  My SQL book
says I can use SUBSTRING(string, 1, 4) in a query but no luck.  I'm  
connecting to an Access database.

btw - this mail list ROCKS!  I've never waited more than 10 minutes for a 
response.

Thanks
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com