RTRIM
Description
Sample Source Pattern
Syntax
RTRIM( string_expression )RTRIM(<expr> [, <characters> ])function RTRIM(string){
return string.replace(/s+$/,"");
}Examples
SELECT RTRIM('LAST TWO BLANK SPACES ') AS [RTRIM]RTRIM |
---------------------+
LAST TWO BLANK SPACES|SELECT RTRIM('LAST TWO BLANK SPACES ') AS RTRIM;RTRIM |
---------------------+
LAST TWO BLANK SPACES|CREATE OR REPLACE FUNCTION rtrim(str varchar)
RETURNS string
LANGUAGE JAVASCRIPT
AS
$$
function RTRIM(string){
return string.replace(/s+$/,"");
}
return RTRIM( STR );
$$;
SELECT RTRIM('LAST TWO BLANK SPACES ') AS RTRIM;RTRIM |
---------------------+
LAST TWO BLANK SPACES|Last updated
Was this helpful?