Re: LENGTH function and trailing spaces

One reason is during a data conversion. You may have a "generic" column for a value, say char(8) and you know the incoming data is only char(4). You can test "select col from ... where length(col) > 4". If you get an answer, either your conversion program is wrong or somebody told a fib about the data. Steve Goldberg Landata RE-Source goldberg@landata.com In article <3mgst1$c2k@dcsun4.us.oracle.com>, kbradley@130.35.1.6 (Kirk Bradley - Mainframe and Integration Technologies) says: > >Now we're getting somewhere. Can you give me an example then >of why you'd ever use LENGTH in SQL? Especially since the >function will not allow an expression? I can't think of >anything particularly useful that LENGTH can do for me. > -end-