try:
....
WHERE field LIKE 'a%' OR field LIKE 'b%'...
Aaron Cooper, BSc
Application Developer, Freeserve.com Plc
The Observatory, 36-41 Clerkenwell Close, London EC1R OAU
T: 0207 553 4992 M: 07799 191 589
-----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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
