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.