Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Trim in dbisam in sql |
Fri, Dec 19 2008 2:05 AM | Permanent Link |
Hiba Hable | Hello,
What is the syntax of the trim function in sql in dbisam? I want to trim a feild in datatable from both sides. Thank you Hiba |
Fri, Dec 19 2008 4:10 AM | Permanent Link |
"Eduardo [HPro]" | Hiba
According with DBISAM help. TRIM Removes repetitions of a specified character from the left, right, or both sides of a string. LTRIM Removes any leading space characters from a string. RTRIM Removes any trailing space characters from a string. Eduardo |
Fri, Dec 19 2008 5:30 AM | Permanent Link |
Hiba Hable | Hello,
How can i write the sql statment if i want to trim a column? thx |
Fri, Dec 19 2008 6:28 AM | Permanent Link |
Fernando Dias Team Elevate | Hiba,
If what you mean is to trim all the existing values in a column, then: UPDATE <tableName> SET <ColumnName> = TRIM(BOTH ' ' FROM <ColumnName>) or, if the type of the column is VARCHAR : UPDATE <tableName> SET <ColumnName> = LTRIM(<ColumnName>) because in that case you only need to remove the leading spaces - trailing spaces are removed automatically for VARCHAR columns. -- Fernando Dias [Team Elevate] |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |