trim long strings

hi how can i trim a char string with 4000 chars? TRIM() only support 255 chars! cu Fasi

Doing something like this MAY work, though I have not tested it: select trim(char[1,200]) || trim(char[201,400]) || trim(char[401,600]) || etc etc etc from .... Good luck and take care. Clifton Bean Fasi <fasi@gmx.net> wrote in message news:7nmd2c$1f9$1@pollux.ip-plus.net... > hi > > how can i trim a char string with 4000 chars? TRIM() only support 255 chars! > > cu > Fasi > >