Sql update doubts

[er_svijayakumar]

Hi
I am using vb.net with access database
I am using sql
How can i update database with the value 40'6"(Feet and inches values)

[thines01]

What is the name and data type of the column?

[Mitja Bonca]

You are using what? Access or sql? These are 2 difference concepts.
You can use varchar (string).

[Begginnerdev]

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

[adam_k]

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.

[adam_k]

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.