to Steve

[jack1971]

Steve,

Thanks for the help. Well, let me put my question in the following way:
1'2"3/16 is the length (US system), which means one foot two inches and three sixteenth. there are one single quote and one double quote involved.
My SQL would be like:
INSERT INTO table VALUES ('string',...), since I don't know how to represent the length by number or decimal, so I try to represent it by text.

Hope this could make the question kinda clearer.

Thanks again.

Jack

 

[Steve101]

Jack,

I liked your heading to this thread. It really got my attention! I have responded in the original thread.
Steve