>Thanks Gregory,
>
>
>>in fact, select left(.., n) returns a char field of length mod(n, 255)
>
>With example i see mod(n, 256)
>
>But this is a documented behaviour or a problem not resolved ?
>
>Fabio
Yeah, sorry, should be mod(n, 256)
As far as I know, it is not documented behaviour. Just found out when I was testing your select left() instead of select padr()
I would not know whether it's problem. I bet no one has ever done that knowing that there is a 254 char limit
Gregory