SEO

#1 (**permalink**) 04-08-2008, 03:16 PM

I need to be able to print the ASCII character 12 (Form Feed) in a print
statement in a Sybase stored procedure.

How do I go about doing this?
Does Sybase support this?

Tom.

#2 (**permalink**) 04-08-2008, 03:16 PM

"Tom Brehony" <tombrehony.nospam@eircom.nospam.net> wrote in message
news:c1fs9q$1hkilj$1@ID-222731.news.uni-berlin.de...
> I need to be able to print the ASCII character 12 (Form Feed) in a
print
> statement in a Sybase stored procedure.
>
> How do I go about doing this?
> Does Sybase support this?
>
> Tom.
>

declare @c char(1)
select @c = char(12)
print @c

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

#3 (**permalink**) 04-08-2008, 03:16 PM

Rob,

Simple and it works. Perfect!

Thanks.

Tom.

"Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
message news:403b8ad9$0$63122$a344fe98@news.wanadoo.nl...
> "Tom Brehony" <tombrehony.nospam@eircom.nospam.net> wrote in message
> news:c1fs9q$1hkilj$1@ID-222731.news.uni-berlin.de...
> > I need to be able to print the ASCII character 12 (Form Feed) in a
> print
> > statement in a Sybase stored procedure.
> >
> > How do I go about doing this?
> > Does Sybase support this?
> >
> > Tom.
> >
>
>
> declare @c char(1)
> select @c = char(12)
> print @c
>
> HTH,
>
> Rob
> -------------------------------------------------------------
> Rob Verschoor
>
> Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
> and Replication Server 12.5
>
> Author of "Tips, Tricks & Recipes for Sybase ASE" and
> "The Complete Sybase ASE Quick Reference Guide"
> Online orders accepted at http://www.sypron.nl/shop
>
> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
> http://www.sypron.nl
> Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
> -------------------------------------------------------------
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How do I print a control character in a Sybase "print" statement?