I have data stored in a string column, and it has white space blank padding on either side:
' john '
' jane '
I would like to remove the left and right space padding on either side - and the padding length is unknown.
Left(name, CHARINDEX (' ', name, CHARINDEX (' ', name) + 1) - 1)