I need to compare two strings in a If-Else block in a stored procedure such as

```
If(@USERNAME='rajat')
begin
select * from table
end
else
begin
select * from table1
end

```

but the problem with the above approach is '=' comparison is case insensitive.I need a approach where the comparison is case sensitive