Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Tue, May 22 2007 7:32 AM	Permanent Link
"Harry de Boer"	LS It seems that only the first char of a column is realy trimmed. update klanten set postcode = trim(leading 'D-' from postcode) only removes the 'D' In dbIsam (3.3) an error occurs that you can only use one char. Regards, Harry
Tue, May 22 2007 8:54 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Harry, << It seems that only the first char of a column is realy trimmed. update klanten set postcode = trim(leading 'D-' from postcode) only removes the 'D' In dbIsam (3.3) an error occurs that you can only use one char. >> You're only allowed to specify one character. I'll make sure that an error is raised. -- Tim Young Elevate Software www.elevatesoft.com
Wed, May 23 2007 3:29 AM	Permanent Link
"Harry de Boer"	Tim, > You're only allowed to specify one character. I'll make sure that an error is raised. Thanks. Regards, Harry "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht news:EDDE7C07-C369-476A-80A6-1A28EFDCA218@news.elevatesoft.com... > Harry, > > << It seems that only the first char of a column is realy trimmed. > > update klanten set postcode = trim(leading 'D-' from postcode) > > only removes the 'D' > > In dbIsam (3.3) an error occurs that you can only use one char. >> > > You're only allowed to specify one character. I'll make sure that an error > is raised. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > >