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

RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.

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

RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.

If it will always be exactly one character, instead of wildcards I would do select blah fromblahtable where left(lastname, 1) in (#listqualify(form.selectbox_of_letters, "'")#) you might have to use something other than left(lastname, 1) if your database uses a different function for

RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.

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