RE: Query about like command

[Zabach, Elke]

Yusuf Gangat wrote: > We have just installed version 7.4.3.10 of the database and I  am having > a problem with a simple sql query that worked in our older version. > The query is : SELECT * FROM STATUS WHERE DESCRIPTION LIKE ‘A*’. > This brings back no result. If I try : > SELECT * FROM STATUS WHERE DESCRIPTION LIKE ‘A%’ it brings back results. > Even though the second query works our software uses the first query with > the ‘*’ wildcard character. Is this a bug that has been fixed in a later version.   With 7.4.3.10 * and % were the same. But as we wrote several times (could be found in the archive!):   Because of our main customer (our own company) we had to change the like-predicate according to SQL92-standard, meaning that only '%' and '_' as written in the docs http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/frameset.htm are handled starting with 7.4.3.17. --> I do not believe that you installed 7.4.3.10      It is no bug, it is a feature      It will not rollbacked   Elke SAP Labs Berlin