Progress
SQL-92
Guide and Reference
PRO_ARR_DESCAPE Function
Removes escape characters from a single element of a character array. PRO_ARR_DESCAPE scans the char_element looking for the separator character ( ; ) or an escape character ( ~ ). The function removes an escape character, when it finds any of these constructs:
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’:
NOTE: char_element should not be the name of an array column, since the column contains true separators which would be destroyed by this function.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |