I've got a database that consists of names. I am requiring to consider individuals names and sort them alphabetically into 4 ARRAY's -> (A-F) (G-L) (M-R) (S-Z). Any methods available which i can use?
Query the database 4 occasions, once for every range. A question appears like this:
select * from T where Name >= 'G' and name < 'M' order by name