Issue with Query

Hello,
I received this query to do a report on all workstations with a particular software and it works for some software but not for running a report on Adobe.

select WORKSTATIONNAME from SystemInfo where WORKSTATIONID IN(select distinct WORKSTATIONID from SoftwareInfo sinfo LEFT JOIN SoftwareList slist ON sinfo.SOFTWAREID=slist.SOFTWAREID where SOFTWARENAME='Adobe Acrobat 8 Standard')

We have several versions of Adobe in our environment and I'm trying to do a search on just the version 8, and I get 0 results when I know we have at least 20 out there. I tried using wild card characters to pull up any Adobe, like Adobe* but that reports 0 as well.

Help would be appreciated.

Thanks