Last post Dec 26, 2016 06:26 PM by scstevelong
Dec 26, 2016 04:40 PM|scstevelong|LINK
I have a table for cities, it has
CityId CityName CountyName
1582 Beaufort Beaufort
1583 Beaufort Carteret
If I run a query ....
select * from cities.... they are all there...but if i....
select * from cities
where countyname = 'beaufort' it returns nothing... any ideas?
Dec 26, 2016 04:55 PM|PatriceSc|LINK
The value could be case sensitive or you may have trailing white spaces? Try to see what happens depending on using:
countyname LIKE 'Beaufort%'
Look at the full and exact definition for your column...
Dec 26, 2016 06:26 PM|scstevelong|LINK
Thank you. I just created a script to change everything in my tables to proper case and that fixed it.. Thank you.