Kbase P34626: Is the Progress SQL-92 Function zero based or 1 based?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/31/2003 |
|
Status: Unverified
GOAL:
Is the Progress SQL-92 SUBSTRING Function zero based or 1 based?
FACT(s) (Environment):
Progress 9.x
FIX:
The Progress SUBSTRING function is 1 based and not zero based. The SQL-92 statement:
SELECT * FROM pub.Customer WHERE SUBSTRING(Name, 3, 1) = 'a';
would return all the records where the THIRD character of the customer Name field is 'a'.