Hey guys...

Is MS SQL Server 2k case sensitive when searching an SQL query?

Eg: If I do a:

SELECT * from table_A where username = 'Smith'

and

SELECT * from table_A where username = 'smith'

What would happen if a "smith" exists in the d/b?