SAP Knowledge Base Article - Preview

1853000 - Msg 249, Level 16, State 1- Syntax error during implicit conversion, derived table\view with concatenation - ASE


Run a query involving a derived table, subquery, at least one aggregate function and a concatenation operation will generate a 249 error:

Msg 249, Level 16, State 1
Syntax error during implicit conversion of VARCHAR value '01' to a DATE field.



  • Sybase Adaptive Server Enterprise (ASE) 15.0
  • Sybase Adaptive Server Enterprise  ASE) 15.5
  • SAP Adaptive Server Enterprise (ASE) 15.7


SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5


min max sum avg count, CR736524 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

About this page

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

Search for additional results

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