>Select:
>
>
> QUOTENAME (InsCompanyID2,'"') AS InsCompanyID2,
>
>
>The result for this column is NULL, I need it to be "".
It works for me:
DECLARE @test varchar(20)
SET @test = NULL
SELECT QUOTENAME(ISNULL(@test,''),'"') AS InsCompanyID2
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.