Kbase P34638: How to replace or assign a SUBSTRING of a table field in SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/12/2009 |
|
Status: Verified
GOAL:
How to replace or assign a SUBSTRING of a Progress table field in SQL-92
GOAL:
How to modify part of a CHAR or VARCHAR field in OpenEdge SQL
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Use the SQL-92 INSERT Function. The statement:
SELECT INSERT(Name,1,1,'B') FROM pub.Customer WHERE SUBSTRING(Name, 1,1) = 'A'
The above query replaces the first letter of all the customers whose name starts with 'A' with 'B'.