My problem is something like this....." 5 feet 6 inch ". This
is a single string(varchar). since i cannot calculate value (6*5)
here .i need to make it taking from database separate. And later
calculate value.Is there any possibility throught which i can do
something like that.?
I could do it for that particular record, but unless every
record has the same structure, it will be tough if not impossible.
How is the data getting into the db to start with? If you are
accepting free text, you might get values like five ft seven, five
and a half ft, etc.
Is it too late to re-design the db so that you have a numeric
field for that measurment?