trim any

CREATE FUNCTION dbo.TRIM_ANY(@input SQL_VARIANT)
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @result VARCHAR(8000)

SET @result = LTRIM(RTRIM(CAST(@input AS VARCHAR(8000))))

RETURN @result

END

SELECT
dbo.TRIM_ANY(OVERRIDERULESET) AS rules,
dbo.TRIM_ANY(QUOTECONDITIONINDICATOR) AS indicator,
dbo.TRIM_ANY(ORDSYNCNUM) AS sync_num,
dbo.TRIM_ANY(created_date) AS date_str
FROM your_table;