468,140 Members | 1,454 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,140 developers. It's quick & easy.

SQL Query Help

I have a query I need to modify and can't seem to get it right, maybe someone can help. I hope

SELECT DISTINCT vrs.Netbios_Name0, vgarp.DisplayName0

FROM v_R_System vrs INNER JOIN
v_GS_ADD_REMOVE_PROGRAMS vgarp ON vrs.ResourceID = vgarp.ResourceID

WHERE (vgarp.DisplayName0 LIKE 'Adobe Acrobat 6% St%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 6% Pro%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 7.0 St%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 7.0 Pro%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 5%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 4%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 3.%')

ORDER BY vrs.Netbios_Name0

Above is the query i have what I need to do is take the Netbios_Name0 results and grab all records that show up more than once. However only a portion of the Name will be the same. For example if a computer shows up as test-dt and test-lt that is a match and I need that to get that data. I hope someone understands this and can help me out.
May 8 '07 #1
0 812

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by netpurpose | last post: by
7 posts views Thread by Simon Bailey | last post: by
36 posts views Thread by Liam.M | last post: by
4 posts views Thread by Doris | last post: by
27 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.