I got the following sample data in my sql Table.
Job Title Annual Salary
Developer £15,000 to £20,000
Developer £15,000 to £20,000
Developer £15,000 to £20,000
Developer £15,000 to £20,000
Developer £20,000 to £25,000
Developer £20,000 to £25,000
Developer £20,000 to £25,000
Developer £20,000 to £25,000
Developer £20,000 to £25,000
Developer £20,000 to £25,000
Developer £20,000 to £25,000
Developer £20,000 to £25,000
Developer £25,000 to £30,000
Developer £25,000 to £30,000
Developer £25,000 to £30,000
Developer £25,000 to £30,000
Developer £25,000 to £30,000
Developer £25,000 to £30,000
Developer £25,000 to £30,000
Developer £30,000 to £35,000
Developer £30,000 to £35,000
Developer £30,000 to £35,000
Developer £30,000 to £35,000
Developer £35,000 to £40,000
Developer Over £40,000
Developer Over £40,000
Developer Over £40,000
Developer Over £40,000
I am trying to built a salary checker tool and want to write a storeprocedure query that would takes salary range as input parameter then divide the Annual salary rows into four main section e.g 1%-25%, 26%-50%,51%-75%,76%-100% and then return output paramet 1 OR 2 OR 3 OR 4 on bases where input salary lies.

If its easy to perform this operation in code behind file then please do let me know.