CODE EXAMPLE FOR SQL

sql trim from string

SELECT TRIM(' text  ');			
SELECT TRIM(BOTH 'x' FROM 'xtextx');