I have a SQL database of over 18,000 addresses and I have been asked to write two reports:
1)that highlights postcodes that have been typed in lowercase;
2)that highlights addresses that have been typed in uppercase.
I don’t want to convert them at all, just find them and I’m writing the report in Crystal so that it runs automatically from our webserver and I never have to write it again.
Any suggestions would be much appreciated.