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

PRO_ARR_ESCAPE( ’char_element’ )  ; 

char_element

The character representation of an array element, without any leading or trailing separators. Must be data type NVARCHAR or VARCHAR or CHAR.

EXAMPLES

The following example returns the string ’aa~;aa’:

PRO_ARR_ESCAPE(’aa;aa’) ; 

The following example returns the string ’aa~aa’. There is no change, since another special character does not follow the escape character:

PRO_ARR_ESCAPE(’aa~aa’) ; 

The third example returns the string ’aa~~;aa’:

PRO_ARR_ESCAPE(’aa~;aa’) ; 

NOTES


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095