LIKE doesn't support regular expressions. You'd have to do "cn LIKE 'a%' OR cn LIKE 'b%'...". However, definitely check your DB's documentation to see if there is a regular expression operator. MySQL has REGEX, for example, which is the same as LIKE, except that it understands regex instead of percent signs.
cheers, barneyb On 9/1/05, Les Mizzell <[EMAIL PROTECTED]> wrote: > Basically, I'm trying to pull up a number of names where the first > letter is in a RANGE being passed by an url variable. > > Something like: > > Select from myTABLE > Where ClientName Like '[a-d]%' > > ...so, it would pull up all clients with names starting with a,b,c, or d. > > But, this isn't working. > > Ideas? > > -- > ----------- > Les Mizzell > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217175 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
