Kbase P34632: How to query a Progress database table in SQL-92 based on a
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/31/2003 |
|
Status: Unverified
GOAL:
How to query a Progress database table in SQL-92 based on a substring value of a field?
FACT(s) (Environment):
Progress 9.x
FIX:
Use the Progress SQL-92 SUBSTRING function. The SQL-92 statement:
SELECT * FROM pub.Customer WHERE SUBSTRING(Name, 10, 2) = 'ab';
returns all the customer records where the 10th and 11th characters in the Customer Name field equal to the string 'ab'.