I am facing a problem writing a query.
The problem is I have a column with different formulas of chemical molecules. for eg CH3Cl
Now I wrote this query
SELECT *from tbl where MolFormula LIKE 'Cb%'
This returns me row 2 and row 3 whereas I just need row 2 to be returned. I am using MS Access. Thanks for looking into it.
Post A Reply