Kbase P45606: How to do a string comparison in SQL-92 stored procedure?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How to do a string comparison in SQL-92 stored procedure?
FACT(s) (Environment):
Progress 9.x
FIX:
You can use "equals" method of Java String class as follows:
CREATE PROCEDURE StringCompare (IN testStr1 VARCHAR(20),
IN testStr2 VARCHAR(20), OUT outbool BIT)
BEGIN
if (testStr1.equals(testStr2))
outBool = new Boolean(true);
else
outBool = new Boolean(false);
END;