SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE FUNCTION [dbo].[to_varchar] (@d varchar(255), @i int) RETURNS varchar(max) with execute as CALLER AS BEGIN declare @to_varchar varchar(255); set @d = replace(@d, '"', ''); set @to_varchar = left(@d, 1); return (@to_varchar); END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO GO