Visual Studio Express 2010
VB.NET
SQL Server 2008

I am having difficulty creating a SQL query to retrieve records where the "Unique" condition is within a cell's value, not being the whole cell itself. To explain this further, I'll show an example of a few records (typed by hand due to font issues)-
Code:
"global_tolerance"     "composite_tolerance"
di0.020ADMEM         di0.010A
di0.020MADMEM       di0.010MA
eo0.020ADMEM        N/A
If I type a query that is something like...
Code:
"SELECT DISTINCT global_tolerance, composite_tolerance FROM panel_definition WHERE 
(global_tolerance LIKE '%di%') AND (global_tolerance LIKE '%eo%')"
...then the above records are returned as three distinct rows, as the first and second records are slightly different. What I need some way of doing is to return the records with "di" in the "global_tolerance" column where the record is unique if the "0.020" portion and "0.010" portion are unique (or, in other words, the first and second records are not considered unique to each other).

Has anyone dealt with this before?