kldesigns
10/30/2019 - 11:34 PM

TRIM White space

SELECT LTRIM(RTRIM('Amit Tech Corp or <insert field>'))

/*LTRIM - removes any leading spaces from left side of string

RTRIM - removes any spaces from right*/