Subject | Appending a CR/LF to a string |
---|---|
Author | GreatDayDan |
Post date | 2002-04-19T21:21:49Z |
Good Morning!
I am trying to build a list of open sales orders
like this:
OpenSalesorders = OpenSalesorders ||
Cast(:SalesOrderId as VarChar(7)) || #13#10;
I would LIKE it to have a CR/LF after each order
id. The line above does not work (compiler chokes on
the #).
The desierd result is something like this:
51239
51347
43945
Can anyone tell me how to do this?
FB 1.0 Super Server on NT 4.
Thanks...Dan'l
=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
I am trying to build a list of open sales orders
like this:
OpenSalesorders = OpenSalesorders ||
Cast(:SalesOrderId as VarChar(7)) || #13#10;
I would LIKE it to have a CR/LF after each order
id. The line above does not work (compiler chokes on
the #).
The desierd result is something like this:
51239
51347
43945
Can anyone tell me how to do this?
FB 1.0 Super Server on NT 4.
Thanks...Dan'l
=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/