Re: Character Field Length Function for Binary Data

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..." \\________________________________________________________________________________________________