Thread: sql by length of data

sql by length of data

From

"Kristopher Yates"

Date:

20 March 2002, 11:27:25

select a, b, c where length(a=2);

How do you do this?  I couldn't find a postgres command for this kind of
call.

Thanks

Re: sql by length of data

From

Andreas Scherbaum

Date:

20 March 2002, 13:24:04

Kristopher Yates wrote:
>
> select a, b, c where length(a=2);
>
> How do you do this?  I couldn't find a postgres command for this kind of
> call.

SELECT a, b, c FROM table WHERE LENGTH(a) = 2;


best regards

--
                                  Andreas 'ads' Scherbaum