Making case-sensitive query

Is there any "select" statement to make a case-sensitive query. The command whisch i gave is...
"select * from (table) where name=(variable)"
which returns all the records where name is equal to the varibale value irrespective of case. What i want is to return all records matching the criterion keeping cases into consideration.