maybe WHERE Left(<fieldname>, 1) BETWEEN 'A' AND 'G'
? this is SQL server, maybe access. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 5:13 PM To: CF-Talk Subject: Results where value starts with A thru G What is the best way to get all of the records where a specific column is LIKE 'A%' through 'G%' ? -chris.alvarado [application.developer] 4 Guys Interactive, Inc. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
