Carriage return /New line in a Text field

Hi
Is there any way to force a carriage return/new line when inserting some
data into a text field?
I'm updating a text field with data from other fields, but in order to make
it look nice on a printout, I'd like to split it onto two lines. I've looked
in BOL, but haven't really been able to find anything that seems to be able
to do it.
Regards
SteenHi Steen,
Please check CHAR in SQL BOL.
I believe CHAR(13) is what you are looking for.
Cheers,
Des
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:u7O7RBvmEHA.3988@.tk2msftngp13.phx.gbl...
> Hi
> Is there any way to force a carriage return/new line when inserting some
> data into a text field?
> I'm updating a text field with data from other fields, but in order to
> make
> it look nice on a printout, I'd like to split it onto two lines. I've
> looked
> in BOL, but haven't really been able to find anything that seems to be
> able
> to do it.
> Regards
> Steen
>|||Yes - that looks like what I was looking for.
Thanks a lot...
Regards
Steen
Des FitzGerald wrote:
> Hi Steen,
> Please check CHAR in SQL BOL.
> I believe CHAR(13) is what you are looking for.
> Cheers,
> Des
>
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> news:u7O7RBvmEHA.3988@.tk2msftngp13.phx.gbl...
>> Hi
>> Is there any way to force a carriage return/new line when inserting
>> some data into a text field?
>> I'm updating a text field with data from other fields, but in order
>> to make
>> it look nice on a printout, I'd like to split it onto two lines. I've
>> looked
>> in BOL, but haven't really been able to find anything that seems to
>> be able
>> to do it.
>> Regards
>> Steen|||You may actually need to use a combination of char(13) +
char(10) depending on your settings. Windows apps
sometimes look for both (Carriage return/linefeed). UNIX
based systems generally only look for the one control
character (Carriage return is a carriage return, line
feed feeds a line but doesn't change your horizontal
position).
Just a thought.
Matthew Bando
Mattehw.Bando@.remove csctgi.com
>--Original Message--
>Yes - that looks like what I was looking for.
>Thanks a lot...
>
>Regards
>Steen
>Des FitzGerald wrote:
>> Hi Steen,
>> Please check CHAR in SQL BOL.
>> I believe CHAR(13) is what you are looking for.
>> Cheers,
>> Des
>>
>> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
>> news:u7O7RBvmEHA.3988@.tk2msftngp13.phx.gbl...
>> Hi
>> Is there any way to force a carriage return/new line
when inserting
>> some data into a text field?
>> I'm updating a text field with data from other
fields, but in order
>> to make
>> it look nice on a printout, I'd like to split it onto
two lines. I've
>> looked
>> in BOL, but haven't really been able to find anything
that seems to
>> be able
>> to do it.
>> Regards
>> Steen
>
>.
>|||Steen Persson wrote:
> *Hi
> Is there any way to force a carriage return/new line when inserting
> some
> data into a text field?
> I'm updating a text field with data from other fields, but in order
> to make
> it look nice on a printout, I'd like to split it onto two lines. I've
> looked
> in BOL, but haven't really been able to find anything that seems to
> be able
> to do it.
> Regards
> Steen *
fmutale02
---
Posted via http://www.webservertalk.com
---
View this thread: http://www.webservertalk.com/message393908.html|||Use a string funtion to select the fisrt part of a string and separate it
with a char(13) or concatenate multiple fileds with the char(13) in between.
Such as
insert into table
select left(field1,10)+char(13)+right(field1,10) from table
or
insert into table
select field1+char(13)+field2
"fmutale02" wrote:
> Steen Persson wrote:
> > *Hi
> >
> > Is there any way to force a carriage return/new line when inserting
> > some
> > data into a text field?
> >
> > I'm updating a text field with data from other fields, but in order
> > to make
> > it look nice on a printout, I'd like to split it onto two lines. I've
> > looked
> > in BOL, but haven't really been able to find anything that seems to
> > be able
> > to do it.
> >
> > Regards
> > Steen *
>
> --
> fmutale02
> ---
> Posted via http://www.webservertalk.com
> ---
> View this thread: http://www.webservertalk.com/message393908.html
>|||Some printers may need both char(13)+char(10) to cause a linefeed.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Jeff Ericson" <JeffEricson@.discussions.microsoft.com> wrote in message
news:358376A2-847C-4108-B5AD-3E615E8A7BB9@.microsoft.com...
> Use a string funtion to select the fisrt part of a string and separate it
> with a char(13) or concatenate multiple fileds with the char(13) in
> between.
> Such as
> insert into table
> select left(field1,10)+char(13)+right(field1,10) from table
> or
> insert into table
> select field1+char(13)+field2
>
>
> "fmutale02" wrote:
>> Steen Persson wrote:
>> > *Hi
>> >
>> > Is there any way to force a carriage return/new line when inserting
>> > some
>> > data into a text field?
>> >
>> > I'm updating a text field with data from other fields, but in order
>> > to make
>> > it look nice on a printout, I'd like to split it onto two lines. I've
>> > looked
>> > in BOL, but haven't really been able to find anything that seems to
>> > be able
>> > to do it.
>> >
>> > Regards
>> > Steen *
>>
>> --
>> fmutale02
>> ---
>> Posted via http://www.webservertalk.com
>> ---
>> View this thread: http://www.webservertalk.com/message393908.html
>>