Perhaps an equally goofy approach would be to have a SpecialStrings table. Have a primary identifier (Like "FB_CRLF"),
and the string to represent as a field. You would have to then use a hand built application (Or script) to add said data
to the database.

Jason


Jarrod Hollingworth wrote:

> I have a stored proc which needs to take a few address fields (street, city,
> state, postal code) and concatenate them in such a way as to have different
> parts appear on different lines, separated by carriage return + linefeed
> pairs, so that they appear in a "memo" type field as they would on an
> envelope. The stored proc returns them in a VARCHAR column.
>
> How can I add CRLF separators? Does it depend on the character encoding?
>
> I cannot rely on UDF functions nor re-formatting in client app code. Ideally
> I need a solution that will work both in Firebird and Interbase.
>
> One trick that a colleague came up with was:
>
> DECLARE VARIABLE CRLF CHAR(2);
> BEGIN
> CRLF = '
> ';
>
> /* Use CRLF */
>
> END
>
> Is that an "as designed" solution that is likely to be supported in future?
>
> Regards,
>
> Jarrod Hollingworth
>
> ++ Q1: Where do you spend your time?
> ++ Q2: Are your projects profitable?
> ++ Q3: Are you billing your customers accurately?
> ++ A : Complete Time Tracking
> ++ Track your time EASILY and ACCURATELY
> ++ http://www.complete-time-tracking.com
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.