dbTalk Databases Forums  

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

comp.databases.sybase comp.databases.sybase


Discuss How do I print a control character in a Sybase "print" statement? in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Brehony
 
Posts: n/a

Default How do I print a control character in a Sybase "print" statement? - 02-24-2004 , 09:57 AM






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.



Reply With Quote
  #2  
Old   
Rob Verschoor
 
Posts: n/a

Default Re: How do I print a control character in a Sybase "print" statement? - 02-24-2004 , 11:32 AM






"Tom Brehony" <tombrehony.nospam (AT) eircom (DOT) nospam.net> wrote

Quote:
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 (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------



Reply With Quote
  #3  
Old   
Tom Brehony
 
Posts: n/a

Default Re: How do I print a control character in a Sybase "print" statement? - 02-25-2004 , 03:14 AM



Rob,

Simple and it works. Perfect!

Thanks.

Tom.

"Rob Verschoor" <rob (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
message news:403b8ad9$0$63122$a344fe98 (AT) news (DOT) wanadoo.nl...
Quote:
"Tom Brehony" <tombrehony.nospam (AT) eircom (DOT) nospam.net> wrote in message
news:c1fs9q$1hkilj$1 (AT) ID-222731 (DOT) 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 (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.