Split text into number and text

[Guest]

Hi ,

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.?

Thanks in advance.

[Dan_Bracuk]

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?