1  select  2   --case (isnumeric(CMF_No)) when 1 then Convert(decimal(18,0),CMF_No)  3   --else Convert(nvarchar(255),CMF_No) end as CMF_No,Disti_Name, 4   --case (isnumeric(Disti_Invoice_Num)) when 1 then Convert(decimal(18,0),Disti_Invoice_Num) else ‘sss‘ end as Disti_Invoice_Num, 5   case  when len(Disti_Invoice_Num)<=1 then null when isnumeric(Disti_Invoice_Num) = 1 then Convert(decimal(18,0),Disti_Invoice_Num) else Convert(nvarchar(255),Disti_Invoice_Num) 6   end as ‘Disti_Invoice_Num‘, 7   Disti_Invoice_Date,Scan_Date,Bar_Code,Product_Code, 8   case (isnumeric(Channel_GID_Num)) when 1 then Convert(decimal(18,0),Channel_GID_Num) else Convert(nvarchar(255),Channel_GID_Num) end as Channel_GID_Num, 9   Channel_Name,Channel_Address 10   11   from OpenDataSource (‘Microsoft.ACE.OLEDB.12.0‘,‘Data Source=C:\Inetpub\wwwroot\DataSynchronization\DownData\2016914164711677.xls;Extended properties=Excel 12.0‘)...[Sheet1$];