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*/