-- Subsititute x for the number of rows you're happy to
-- delete at a time in order to limit transaction log growth
DELETE TOP(x)
FROM MyTable
WHERE MyColumn = 'Non -US'
-- Rinse and repeat

John