Roger Alcindor
asked on
Case Sensitive SQL Query
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER