SAP Knowledge Base Article - Preview

2477577 - Like condition fails to return data when using square brackets - ASE

Symptom

  • Using SAP Adaptive Server Enterprise (ASE)
  • "like" clause using square brackets  not rerturning values in 15.7
  • same query in 15.5 returns correct values
  • Example of syntax:
     select * from likeissue where b like '1234  Report [[[]]FS1F[]]'


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0 and higher

Product

SAP Adaptive Server Enterprise 15.7

Keywords

like operator, square brackets, CR 639877, CR 703975, CR639877, CR703975   , 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 for Me (Login required).

Search for additional results

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