Kjell Rilbe skriver:

> Paul Vinkenoog skriver:
>> > In the documentation for LPAD and RPAD is written that the result
>> type is VARCHAR(32765) and there is a tip to cast the result to a useful
>> length.
>> >
>> > When using LPAD or RPAD in a "SELECT LPAD( LABEL, 8, '-' ) FROM...",
>> FlameRobin and IBExpert both return a VARCHAR(8), corresponding to the
>> length argument of xPAD(), without casting.
>>
>> In Firebird 2.5, the result is VARCHAR(n) with n equal to the second
>> argument.
>
> Does this mean that if I have a varchar(n) col and want to pad those
> values that are shorter than k chars to m chars (n>= m>= k), I can't
> do it without also truncating values longer than m to m chars?
>
> E.g. column "x" is varchar(10) and I have these values:
>
> 'abcdefghij'
> 'a'
> 'abcde'
>
> select rpad("x", '-', 6) from thetable

Sorry, that should be:
select rpad("x", 6, '-') from thetable

> would return this:
>
> 'abcdef'
> 'a-----'
> 'abcde-'
>
> Or would it throw an exception?
>
> Kjell

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64