CREATE FUNCTION dbo.ParseTextQualified (@TextQualifier VARCHAR(10),
@Input VARCHAR(MAX))
RETURNS VARCHAR(MAX)
AS
BEGIN
RETURN
(SELECT CASE WHEN LT >= 2 * TQL
AND LEFT(@Input, TQL) = @TextQualifier
AND RIGHT(@Input, TQL) = @TextQualifier THEN SUBSTRING(@Input, TQL + 1, LEN(@Input) - TQL * 2)
END
FROM (SELECT LEN (@TextQualifier) AS TQL, LEN (@Input) AS LT) a
)
END