Remove all spaces from string sql

Sql remove spaces

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

Remove all spaces from string sql

SELECT REPLACE(' Hello World ',' ')

-2

Remove spaces sql 2008

SELECT RTRIM(LTRIM(' Word '))

-3

Source: blog.sqlauthority.com

Similar codes

1 vote209 views1 answer
Get parameter value in mysql trigger
SQL
1 vote210 views2 answers
Oracle list service names
SQL
0 vote207 views1 answer
Power query case when
SQL
11 votes193 views2 answers
Sql between date range
SQL
1 vote212 views1 answer
Sql avg group by
SQL
0 vote199 views1 answer
No suitable driver found for sqlite
SQL
2 votes219 views1 answer
Q operator in oracle
SQL
3 votes220 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
1 vote208 views1 answer
Select not matching data with join table
SQL
10 votes217 views4 answers
Drop primary key
SQL