How to solve the error in conversion bigint to varchar SQL?

465    Asked by DaniloGuidi in Salesforce , Asked on Aug 22, 2023

 I am getting an error that shows an error while converting varchar to bigint. This issue is coming from the where clause. But I cannot solve this problem. Is there any suggestion?

Answered by Diana Campbell

You are getting the error converting data type varchar to bigint because you store the data with a varchar data type into an integer type field. Observing the datatypes you have used, table fields of the data table, and data extension, and using the convert or format function can help solve the issue.


Your Answer

Interviews

Parent Categories