Subject | Stripping whitespace |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2003-04-04T10:34:45Z |
I noticed that on of my tables had CHAR(30) field instead VARCHAR
I converted the field with small script, but the spaces at the end of data came also over.
Now I have "Riho ", but I want to have "Riho".
Is it possbile to easily get rid of these spaces using Firebird ?
Riho-Rene Ellermaa
senior programmer
Hansabank
I converted the field with small script, but the spaces at the end of data came also over.
Now I have "Riho ", but I want to have "Riho".
Is it possbile to easily get rid of these spaces using Firebird ?
Riho-Rene Ellermaa
senior programmer
Hansabank