curiouswebster
asked on
SQL Syntax: How to force case sensitive query?
I want to get four query results, not two:
select count(*) as SecondYearInterestIsNo from APSecondYear where SecondYearInterest='No'
select count(*) as SecondYearInterestIsNO from APSecondYear where SecondYearInterest='NO'
select count(*) as SecondYearInterestIsYes from APSecondYear where SecondYearInterest='Yes'
select count(*) as SecondYearInterestIsYES from APSecondYear where SecondYearInterest='YES'
How do I make this query CASE SENSITIVE?
I want to differentiate between No and NO.
Thanks
select count(*) as SecondYearInterestIsNo from APSecondYear where SecondYearInterest='No'
select count(*) as SecondYearInterestIsNO from APSecondYear where SecondYearInterest='NO'
select count(*) as SecondYearInterestIsYes from APSecondYear where SecondYearInterest='Yes'
select count(*) as SecondYearInterestIsYES from APSecondYear where SecondYearInterest='YES'
How do I make this query CASE SENSITIVE?
I want to differentiate between No and NO.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER