Kbase P22123: How to convert an integer to a string in SQL89 / ESQL-C?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/03/2003 |
|
Status: Unverified
GOAL:
How to convert an integer to a string in SQL89 / ESQL-C?
FIX:
To convert an integer field from a database to a string so that it can be used in the WHERE clause of a SELECT statement, use the following code:
SELECT * FROM SomeTable1, SomeTable2
WHERE STRING(SomeTable1.SomeIntegerField) = SomeTable2.SomeCharacterField)