From: Umberto (umbertoengineer.com)
Date: Fri Jul 04 2003 - 00:38:57 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]