Subject Re: DML - Inserting ASCII characters into a string?
Author Adam
> Is there a DML function or other means available to insert ASCII codes
> into a VARCHAR?
>
> I have a stored procedure that returns a VARCHAR, and I would like to
> insert non-typeable ASCII characters, such as tab or carrige return
> (ASCII code 13) into the return value.

There is no 'DML function', but by the same token, I don't see the
problem with tab or crlf?

-- Return tab
SomeValue = ' ';

-- Return CRLF
SomeValue = '
';

If you wanted an ascii number->char function however, you should take
a look at ib_udf.sql in your udf folder

DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CSTRING(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';

Adam