.  I included a chr(10) and
> chr(13) (line-feed and character returns)

This will indeed case two boxes!

It should be chr(13) followed by chr(10) :>)

ie

dim nl
  nl=chr(13) & chr(10)

HTH
Frank
----- Original Message -----
From: "Emerald Spirit" <emerald_spirit(at)yahoo.com>
To: <hwg-techniques(at)hwg.org>
Sent: Wednesday, August 29, 2001 7:45 PM
Subject: SQL question


> Hi all!
>
> I've been banging my head up against the wall for the
> better part of the day today over the following
> problem:
>
> I need to do something that seems so simple.  I'm
> running an insert SQL statement from an ASP page.  The
> database is SQL Server 7.0.  This database has a text
> field with a len of 16.  Another application running
> off of this database and entering data into it.
>
> I need to match what its entering so that my system
> won't upset the current system.  In this text field,
> its entering what appears to be carriage returns into
> the data, just as if you typed the data directly into
> the field and pressed shift + enter to get a new line.
>  I'm trying to create the SQL statement that will
> write out a string into that field including those
> character returns.
>
> I understand VB very well and have done versions of
> this in Access database.  I included a chr(10) and
> chr(13) (line-feed and character returns) in the SQL
> statement.  Its writing the characters to the field in
> the database, but they are not having the desired
> effect.  Instead of showing as a new line, they are
> just showing as two boxes.
>
> I know this is possible, and I know I've got to be
> close.  Any suggestions???
>
> TIA
>
> Rebecca
>
> =====
> Do while Project<>Completed
>    if impossible = true then
>       rethink(approach)
>       set impossible = false
>    end if
> loop
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger
> http://im.yahoo.com

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA