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
