On Mon, Dec 10, 2001 at 02:04:59PM +0000, Wiliam Stephens wrote: > 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?
If you just want Wales, then use =, not LIKE. WHERE res_place = 'Wales' Ronald
