Thread: Text manipulation
View Single Post
  #2 (permalink)  
Old 03-25-2008, 08:13 AM
ee_rlee ee_rlee is offline
Junior Member
  
Join Date: Mar 2008
Posts: 2
ee_rlee is on a distinguished road
Default ANY answer. Re: Text manipulation
hi, try this

SELECT A.*
FROM TableA A INNER JOIN Table B ON ',' + A.Platforms + ',' LIKE '%,' + B.Platform + ',%'
WHERE B.Platform='One'
Reply With Quote