SELECT TOP (10) Reputation 
FROM Users 
WHERE LOWER(Location) LIKE '%bocaraton%' 
      OR LOWER(Location) LIKE '%boyntonbeach%'
      OR LOWER(Location) LIKE '%delraybeach%'
      OR LOWER(Location) LIKE '%deerfieldbeach%'
      OR LOWER(Location) LIKE '%coconutcreek%'
      OR LOWER(Location) LIKE '%coralsprings%'
      OR LOWER(Location) LIKE '%margate%'
      OR LOWER(Location) LIKE '%pompanobeach%'
ORDER BY Reputation DESC;

#GO