Case Sensitive SQL Query

Roger Alcindor
Roger Alcindor used Ask the Experts™
on
I wish to perform a case sensitive query on an SQL Server table.
I have found an example :
Select * from a_table where attribute = 'k' COLLATE Latin1_General_CS_AS

Can I be assured that executing this query will not affectsubsequent queries that don't have the COLLATE statement ?

In other words, the default COLLATION for the table will not be affected ?

Thanks,

Roger
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
Yes

Author

Commented:
Thanks Jim

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial