5
Contributors
5
Replies
6
Views
5 Years
Discussion Span
Last Post by adam_k
0

If the column is a varchar, just simply store the value as you wish.

If it is a numerical value, you can use decimal places to seperate the value.

Example:

40.6

0

For me the best option would be to save it as inches.
With the use of 2 functions you'll never know that you are saving in inches and you'll be able to make calculations and comparisons (is this longer than that or whatever).
What you'll need is a function that will multiply the feet by 12 and then add the inches (in order to save it to the db), and a function that will read the inches and will perform floor(inches/12) & "'" & ((inches - floor(inches/12))*12) & """
or something like that.

Edited by adam_k: correction

0

now that I look at my post, perhaps it would be better to explain it a bit more:
floor(inches/12) will give feet and(inches - floor(inches/12))*12 will give the remaining inches.

Edited by adam_k: corrections

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.