db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Ondruška <peter.ondru...@gmail.com>
Subject Re: Does derby have keyword like Max-length in sqlserver?
Date Tue, 27 Jul 2010 07:44:22 GMT
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?


View raw message