Hello, We are implementing a simple billing system using SAPDB 7.4 under Linux (Redhat 9 and SuSE 8.1) that requires some basic pattern matching with ranges.
According to this thread, it supports just what we need: http://listserv.sap.com/pipermail/sapdb.general/2001-September/008355.html However, the range spec doesn't seem to work. For example, assuming that the table Billing has a record with the value '9665277273' in the cNumber column, the following query does not return any results: SELECT * FROM Billing WHERE cNumber LIKE '966(0-5)*' On the other hand, this does: SELECT * FROM Billing WHERE cNumber LIKE '9665%' The latter is not practical since the user would have to query for every number between 9660% and 9665% individually. Am I missing something? Umberto _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
