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??