Progress
SQL-92
Guide and Reference
PRO_ARR_ESCAPE Function
Adds required escape characters to a single element of a character array.
PRO_ARR_ESCAPE scans the char_element looking for the separator character ( ; ) or an escape character ( ~ ). The function inserts an additional escape character, when it finds any of these constructs:
SYNTAX
char_element
The character representation of an array element, without any leading or trailing separators. Must be data type NVARCHAR or VARCHAR or CHAR.
EXAMPLESThe following example returns the string ’aa~;aa’:
The following example returns the string ’aa~aa’. There is no change, since another special character does not follow the escape character:
The third example returns the string ’aa~~;aa’:
NOTES
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |