LIKE and =

DrugType is a char (10) field

Like can query wildcard:

SELECT *

From drug1

WHERE (DrugType Like 'a%')

= Only exact value query:

SELECT *

From drug1

WHERE (DrugType = 'a')

Use

SELECT *

From drug1

WHERE (DrugType = 'a%')

Can't find out