There is built-in function LENGTH (refguide.pdf page 130)

connect 'jdbc:derby:test;create=true';
create table test(col varchar(100));
insert into test values('short');
insert into test values('longer');
insert into test values('very long text');
select col, length(col) from test;


On Mon, Jul 26, 2010 at 8:55 AM, wendong zhou <zhouwendong120@gmail.com> wrote:
> Hi,I want to query length of column.For example, Table A has a column which
> is named colA,and the type is varchar, length is 50. Now, I want to use a
> sql to select the length of this column. How can I write?
>



-- 
http://www.google.com/profiles/peter.ondruska