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.

__________________
Cheers
Sheraz