Sql rtrim

Rtrim sql

SELECT TRIM('   Exemple   ');						-- 'Exemple'
SELECT LTRIM('   Exemple   ');						-- 'Exemple   '
SELECT RTRIM('   Exemple   ');						-- '   Exemple'
SELECT TRIM(BOTH 'x' FROM 'xxxExemplexxx');			-- 'Exemple'
SELECT TRIM(LEADING 'x' FROM 'xxxExemplexxx');		-- 'Exemplexxx'
SELECT LTRIM('xxxExemplexxx', 'x');					-- 'Exemplexxx'
SELECT TRIM(TRAILING 'x' FROM 'xxxExemplexxx'); 	-- 'xxxExemple'
SELECT RTRIM('xxxExemple', 'x');					-- 'Exemplexxx'

Source: sql.sh

Sql rtrim

SELECT RTRIM('SQL Tutorial     ') AS RightTrimmedString;

Similar codes

8 votes205 views1 answer
Oracle search code in packages
SQL
0 vote126 views1 answer
Oracle list index on table
SQL
0 vote130 views1 answer
Fast sql column count
SQL
0 vote146 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote140 views1 answer
How to reset the database value in SQL server
SQL
3 votes124 views2 answers
To_char sql
SQL
1 vote126 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote131 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
22 votes145 views3 answers
Remove all records from table mysql
SQL
0 vote145 views1 answer
Drop database using terminal postgres
SQL