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)

What is the name and data type of the column?

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

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

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.

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.