SAP Knowledge Base Article - Preview

2530487 - Error 257 "Implicit conversion from datatype..." in SELECT query on multiple views with UNION ALL and LEFT JOINS - SAP ASE


  • A SELECT statement on multiple views with UNION ALL and LEFT JOINs generates:

Error 257 Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed.  Use the CONVERT function to run this query.

  • The issue only happens with  LEFT JOINs  as with RIGHT JOIN no error has been seen.  



  • SAP Adaptive Server Entreprise (ASE) 15.7
  • SAP Adaptive Server Entreprise (ASE) 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


Error: 257, view with union all, split, separate, query failing , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.