Height Search problem

Hi,

We have a member database where each member inputs their height. Currently we have a feet field and an inches field.

What our client needs is for people to be able to search for members by height within a + or - 1 inches. So, if the height search is 5'8" it would return members that are 5'7 or 5'8 or 5'9. As people think in feet and inches for height, having the height field in inches only for input is not an acceptable solution.

Can you think of any way that CB 2 could solve this problem? Is there a way to store the height in inches in the database but have the frontend view be able to convert that value into a feet/inches number for display? If height was an integer number then we could use the range search, so the user could enter 5'6 to 5'9 or any range they wanted and not be limited to the + - 1 inch limitation (display value would need to be converted back to straight inches transparently by the software). That would also be acceptable, as long as the range was entered in feet/inches and not just in inches.

Thank you for any help on this.

If you use integer fields then and set your userlist searching to simply any or advanced they can search an integer range. Besides that the only way to have what you're wanting exactly is a custom CB fieldtype plugin that has its own custom searching functionality (basically extend the integer field with customized searching), but that's by no means any easy task unless you're familiar with CBs API and plugin structure. Screenshot as follows for integer search range.