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 -- Just Testing! WHERE ChartID = '1601' GO SET ANSI_PADDING OFF