SQL Trim Functions Remove White Space (Trim(), lTrim, rTrim)
Filed under SQL
Here is just another little way to remove white space. Use SQL Trim(), lTrim() and rTrim().
SELECT Trim( ' Variable ' );
Output: 'Variable'
SELECT lTrim( ' Variable ' );
Output: 'Variable '
SELECT rTrim( ' Variable ' );
Output: ' Variable'
Feb24