Collations cannot be changed specifically for columns, they effect the whole DB.

But you can temporarily change them like this:

SELECT top 10 firstname COLLATE SQL_Latin1_General_CP1_CI_AS FROM users