Syntax error (missing operator) in query expression 'InvoiceNumber =''123A''

Hello,

I am trying to update the excel sheet with SQL query but I observe this error for alphanumeric value

“update [”+sheetname+"$] set [StartTime]=’"+In_StaartTime+"’, [EndTime]=’"+In_endTime+"’,[Status]=’"+Status+"’ Where InvoiceNumber =’"+in_invoiceNumber.ToString+"’ "

variable invoiceNumber in patter ’ " " ’

This query works if InvoiceNumber is Int (123)
The error is observed if the InvoiceNumber is (123A- alphanumeric)

Your guidance is appreciated
Thanks
Greeshma

Hi @Greeshma_Sripada1
welcome to forum
just a doubt, are u updating sql table or excel file in your case?