>Also perhaps there is a SQL Server function that adds double quote, I just don't recall.
>
>Not sure why do you need to add " in front and perhaps it would be easier to do some extra processing in VFP after you get results, but here I see problems
>
>'"' + cast('' as varchar(12)) WorkPhone + '"' AS WorkPhone,
>
>should be
>
>'"' + cast('' as varchar(12)) + '"' AS WorkPhone,
>(and I guess you need to use char(12) and not varchar)
>
>You have same problems in other fields bellow.
Looking much better, thanks. Getting another error now:
Msg 245, Level 16, State 1, Line 2
Conversion failed when converting the varchar value '"' to data type int.
USE IMPACTMD
GO
SELECT
'"' + LastName + '"' AS LastName,
'"' + FirstName + '"' AS FirstName,
'"' + MI + '"' AS MI,
'"' + Address1 + '"' AS Address1,
'"' + Address2 + '"' AS Address2,
'"' + City + '"' AS City,
'"' + State + '"' AS State,
'"' + Zip + '"' AS Zip,
'"' + SSN + '"' AS SSN,
'"' + Phone + '"' AS Phone,
'"' + cast('' as varchar(12)) + '"' AS WorkPhone,
'"' + cast(DOB as varchar(12)) + '"' AS DOB,
'"' + Sex + '"' AS Sex,
'"' + InsCompanyID + '"' AS InsCompanyID,
'"' + InsCompanyID2 + '"' AS InsCompanyID2,
'"' + cast('' as varchar(12)) + '"' AS Reserved01,
'"' + cast('' as varchar(12)) + '"' AS Reserved02,
'"' + cast('' as varchar(12)) + '"' AS Reserved03,
'"' + cast('Family_Physician_Last_Name' as varchar(30)) + '"' AS Family_Physician_Last_Name,
'"' + cast('Family_Physician_First_Name' as varchar(30)) + '"' AS Family_Physician_First_Name,
'"' + cast('' as varchar(12)) + '"' AS Reserved04,
'"' + cast('Referring_Physician_Last_Name' as varchar(30)) + '"' AS Referring_Physician_Last_Name,
'"' + cast('Referring_Physician_First_Name' as varchar(30)) + '"' AS Referring_Physician_First_Name,
'"' + cast('' as varchar(12)) + '"' AS Reserved05,
'"' + Provider1 + '"' AS Provider1,
'"' + Provider2 + '"' AS Provider2
FROM Patients
WHERE ChartID = '1601'
GO
SET ANSI_PADDING OFF