Is there a way to create a select statement that will select a record if the exact term is found in a field that contains the text to describe something? If I create a select statement using WHERE description LIKE ‘art’ I get every record that has words like depart, start and so on. If I create a select statement using WHERE description = ‘art’ I get no results even though the word art is in some records description field. Thanks Marc |