Nope, it's one of those functions that does not work in Access. Just like SET, or @@Identity, or a few others I can't think of right now :)
______________________ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 1:17 PM To: CF-Talk Subject: RE: Substring function in query Mark, um no... I mean are you using MS SQL Server (sql 7 or 2000). I'm not altogether positive that the SUBSTRING( ) function works in Access - never tried it. However, the syntax you entered before is practially letter for letter like the examples in SQL servers documentation. Maybe someone else out there can verify if SUBSTRING( ) is valid in Access? Mark ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
