Instead of res_place LIKE '%Wales%' use res_place = 'Wales' ____________________ Chris Spurgeon Senior Design Technologist [EMAIL PROTECTED]
ELECTRONIC INK One South Broad Street 19th Floor Philadelphia, PA 19107 www.electronicink.com t 215.922.3800 x(233) f 215.922.3880 -----Original Message----- From: Wiliam Stephens [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 9:05 AM To: [EMAIL PROTECTED] Subject: SQL Wildcards Hi I want to select a few records from a database, but I'm having trouble pinning down the correct method for my SQL call. I have a SET field with the following options: 'Wales','Mid Wales','North Wales','South Wales','West Wales','Towns & Cities in Wales' I want my search program to search for a record that has is in 'Wales'. However, when I try: res_place LIKE '%Wales%' That returns all records that are in 'Wales','Mid Wales','North Wales' and so forth. So how do I create a SQL call that will match the option 'Wales' and nothing else? Thanks for your help. Wiliam Stephens Web Developer http://www.fbagroup.co.uk This e-mail is intended solely for the above-mentioned recipient and it may contain confidential or privileged information. If you have received it in error, please notify us immediately and delete the e-mail. You must not copy, distribute, disclose or take any action in reliance on it. In addition, the contents of an attachment to this e-mail may contain software viruses which could damage your own computer system. While Electronic Ink, Inc. has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should perform your own virus checks before opening the attachment.
