I'm having a little trouble with a SELECT query. I keep reading here that a query like:

select countyname from tblcounties where countyname like 'N%'

should return the same results as:

select countyname from tblcounties where countyname like 'n%'

BUT with the first one I get all of the results from the table I want and the second one returns nothing. All of the values in the table hav a capital at the begining.

Anyone know what I'm doing wrong??