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

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