Help w/ query

From: Greg (Greg_at_discussions.microsoft.com)
Date: 02/02/05 

Date: Tue, 1 Feb 2005 19:51:01 -0800

I need help typing to pull info out of a SMS database. We are selecting info
from three table. we inner join the tables to get selected info out. where
we are having trouble is by limiting what is returned. is there a way to say
"if the row has a specific character(s) then the row will be ignored". the
way it is now gives us about ten time the data, because the machine name is
associated with multiple collections within sms.