USFormat.CharAddIOFormat

Formats a string using a string IO format pattern.

Returns the result of applying the IO format pattern to the string.

Syntax

SELECT USFormat.CharAddIOFormat(

       string

,      string-io-format-pattern

)

Both string and string-io-format-pattern are required. String-io-format-pattern must be one of the USoft IO format patterns used for string values.

Example

SELECT USFormat.CharAddIOFormat(

       'YESNO'

,      'XXX/XX'

)

The return value of this statement is:

YES/NO