PatientID = record["PatientID"].ToString() == "0" ? string.Empty : record["PatientID"].ToString(),
ISNULL(Convert(Varchar(50),PC.PatientID),'') AS 'PatientID',
SELECT [VendorID], ISNULL(Convert(varchar(50), [PatientID]),'0') AS PatientIDFROM [dbo].[TBL_Vendor]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)