new line character

Is there a way to insert a "new line/carriage control" in a varchar column? 
 <Ctrl><Enter> keys work with a text column but just tabs to next control 
on a varchar column. Tried ~r~n but that just stores/prints the text ~r~n.

Seems that <ctrl><enter> used to work in the app.

PB 7.02 9028

You can use char(10) + char(13) to get the cr/lf

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
MySybase http://my.sybase.com/mysybase
Search Deja: http://www.pfcguide.com/_newsgroups/search.asp

<Mike> wrote in message
news:[email protected]
> Is there a way to insert a "new line/carriage control" in a varchar
column?
>  <Ctrl><Enter> keys work with a text column but just tabs to next control
> on a varchar column. Tried ~r~n but that just stores/prints the text ~r~n.
>
> Seems that <ctrl><enter> used to work in the app.
>
> PB 7.02 9028

Actually, I think char (13) + char (10) will get you CR/LF. 

Terry [TeamSybase] and Sequel the nit-picking techno-kitten

On Tue, 27 Feb 2001 09:24:13 -0700, "Terry Dykstra"
<[email protected]> wrote:

>You can use char(10) + char(13) to get the cr/lf


Sequel's Sandbox: http://www.techno-kitten.com
Home of PBL Peeper, a PowerBuilder Developer's Toolkit, 
winner of PowerTimes 1999 "Little Helper of the Year"

picky picky <g>

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
MySybase http://my.sybase.com/mysybase
Search Deja: http://www.pfcguide.com/_newsgroups/search.asp

"Terry Voth" <[email protected]> wrote in message
news:[email protected]
> Actually, I think char (13) + char (10) will get you CR/LF.
>
> Terry [TeamSybase] and Sequel the nit-picking techno-kitten
>
> On Tue, 27 Feb 2001 09:24:13 -0700, "Terry Dykstra"
> <[email protected]> wrote:
>
> >You can use char(10) + char(13) to get the cr/lf
>
>
> Sequel's Sandbox: http://www.techno-kitten.com
> Home of PBL Peeper, a PowerBuilder Developer's Toolkit,
> winner of PowerTimes 1999 "Little Helper of the Year"

Yeah, but how can the user enter that into the control. For example if they 
enter "My address is 123 Main Street~r~nCityname"
it prints the ~r~n(or char(10)+char(13) instead of a line feed.
It just stores that as text. 

Thanks for your help... 

Are you using a dw? Otherwise you could choose a mle.
Why do you want to store street, streetno and city in one varchar()?

Uwe

Mike_M wrote:

> Yeah, but how can the user enter that into the control. For example if they
> enter "My address is 123 Main Street~r~nCityname"
> it prints the ~r~n(or char(10)+char(13) instead of a line feed.
> It just stores that as text.
>
> Thanks for your help...