SQL Server avoid repeating the collation type multiple times in a query
You can once create a view using column definitions like this:

FirstName COLLATE SQL_Latin1_General_CI_AS, ...


Then anytime you'd like to use User tables, you can use this view instead.