SELECT EXISTS (SELECT 1 FROM myTable WHERE Company='SmartCO'); Your query would return *all* of the names in myTable if at least one of them is named 'SmartCo'.
SELECT EXISTS (SELECT 1 FROM myTable WHERE Company='SmartCO'); Your query would return *all* of the names in myTable if at least one of them is named 'SmartCo'.