[SOLVED] Is it possible to remove space (spaces) from Firebird
Varchar() field ?
lazarus / 16-Databases

----------------------------------------------------------------------
finalist · 2016-01-07 15:44

I must to be absolute sure that a Firebird varchar field contains 
some text. But if it contains one space or more spaces, I will not
consider that as a text, but as a not correct data.
Is in Firebird some method like Trim() in Pascal ?
If the varchar() field contains one space or more spaces to be
converted to empty;
If the varchar() field contains utf-8 text like ´   Text  ´  to be
converted to ´Text´.
After above Trim() process I will use next code in a Trigger of a
Firebird table:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i IF not
(FIELDofVARCHAR = ´´ OR FIELDofVARCHAR is NULL) THENBEGIN 
/*........*/END

----------------------------------------------------------------------
taazz · 2016-01-07 15:50

first hit on google
http://www.firebirdsql.org/refdocs/langrefupd20-trim.html