SQL question

by Emerald Spirit <emerald_spirit(at)yahoo.com>

 Date:  Wed, 29 Aug 2001 16:45:10 -0700 (PDT)
 To:  hwg-techniques(at)hwg.org
  todo: View Thread, Original
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

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