InterSystems SQL Reference
RTRIM
|
|
RTRIM(string-expression ) {fn RTRIM(string-expression )}
A string expression, which can be the name of a column, a string literal, or the result of another scalar function, where the underlying data type can be represented as any character type (such as CHAR or VARCHAR). |
SET a=" Test string with 5 leading and 5 trailing spaces. " &sql(SELECT {fn RTRIM(:a)} INTO :b) IF SQLCODE'=0 { WRITE !,"Error code ",SQLCODE } ELSE { WRITE !,"Before RTRIM",!,"start:",a,":end" WRITE !,"After RTRIM",!,"start:",b,":end" }
Before RTRIM start: Test string with 5 leading and 5 trailing spaces. :end After RTRIM start: Test string with 5 leading and 5 trailing spaces.:end
Content for this page loaded from RSQL_rtrim.xml on 2018-02-01 14:30:12
|