Count Rows Between a Range
Posted on 2012-08-11
I have an existing database that was made some time back (16 years) and there wasn't much validation that was taking place. I have a column called "income" which is Varchar. Needless to say it had a lot of non numeric characters in it. I have cleaned those up and am left with results such as 100 or 100.00. What I need to do now is write a query which would count those records into ranges such as : 0-150, 151-250, 251-500, etc. I've not been able to locate something that has worked so far. Any help would be greatly appreciated.