On 8 May 98 at 8:00, David & Adina Samson wrote:
> Does anybody know of a function which returns the length actually
> used in a character field when we store binary data? For example,
> if I've got a field defined as "char(20)" with a value of
> "0xa73123", I want to a function to return a value of 3. The basic
> "length" and "char_length" return the defined size of the field
> (20).
Sorry, I must just be exceedingly dumb, but how does a string of
"0xa73123" have a length of 3? If I ask for the length of that string
in 4GL, I get 8.
--
Ciao,
Billy
/Group Managing Director, The West Solutions Group: http://www.west.co.za
\\ Drivel @ http://www.west.co.za/tasteless/
/
\\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I
/ think we should go along with him..."
\\________________________________________________________________________________________________