SAP Knowledge Base Article - Preview

1912336 - Different behavior between UltraLite database versions with SUBSTRING function

Symptom

  • For an UltraLite database, if you run the following SQL in 9.0.2:
    SELECT SUBSTRING('Hello World', 0, 10)
    it returns 'Hello Worl'
  • Running the same SQL query in UltraLite 12.0 or above, it returns:
    'Hello Wor'

Read more...

Environment

  • SAP UltraLite 12 or above

Product

SAP SQL Anywhere all versions

Keywords

truncation truncate ANSI substring , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , How To

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.