Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
trim function |
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 > > |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |