Rif, It is an MSAccess db. Paul > -----Original Message----- > From: Rif Kiamil [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 06, 2001 12:01 PM > To: CF-Talk > Subject: RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc. > > > What type of database u using ? > > Rif > > -----Original Message----- > From: Paul Sinclair [mailto:[EMAIL PROTECTED]] > Sent: 06 April 2001 16:25 > To: CF-Talk > Subject: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc. > > I am trying to get a db output where a user selects an > alphabetical range in > a form and then the sql selects all users in a db whose last names start > with one of the letters in that range. For example, on a form > page the user > selects a range of a-f. I need to find all users whose last names > start with > a letter in that range and output the results. > > I think I recall a simple way to do this, but right now can't think of it. > Could anyone jog my memory for me? > > Thanks, > Paul Sinclair > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
