Case sensitive query ?

How do I make a case sensitive query.
For e.g
Select * from myTable where Password='AaBb'
and
Select * from myTable where Password='aabb'
returns same records.
How do I make a case sensitive query so that 'AaBb' and 'aabb' are different(a) collate the column as case sensitive (see collate in books online, 2000
only)
(b) make the entire database case sensitive
(c) convert each side of the comparison to varbinary
"Arsalan" <arsalan_aslam@.hotmail.com> wrote in message
news:eWJg9y$aDHA.384@.TK2MSFTNGP12.phx.gbl...
> How do I make a case sensitive query.
> For e.g
> Select * from myTable where Password='AaBb'
> and
> Select * from myTable where Password='aabb'
> returns same records.
> How do I make a case sensitive query so that 'AaBb' and 'aabb' are
different
>
>sql