Case sensitive filtering in SQL server

For case sensitive:
put COLLATE SQL_Latin1_General_CP1_CS_AS after filer........
For Case incensitive:
put COLLATE SQL_Latin1_General_CP1_CI_AS after filer........


Example: select * from tablename where upper(columnNmae1)!=columnNmae1 COLLATE SQL_Latin1_General_CP1_CS_AS