Determine whether SQL is case sensitive? ?

SELECT CASE WHEN ('a' = 'a') Then 'does not distinguish case' else 'Case case case' endGO