Re: Character Field Length Function for Binary Data

On 10 May 1998 14:51:02 GMT, "David Samson" <dsamson@ndsisrael.com> wrote: >Billy wrote to me to ask what this "0xa73123" syntax is. I guess this is >from a previous, other database life. What I meant by that was a field >with a value of "a73123" (hex). How can I get an SQL function to return >"3" as the length of this field (i.e. 3 bytes worth of real data)? The regular sql length function should return 3 if you make sure the rest of the column is filled by spaces. If it contains hex 0 or anything else you will not get 3 as a result. The length function counts from the start until the last character that is not a space, but followed by nothing but spaces. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)