Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rabbitfood

    Select vbCRLF as part of a string for Insert

    Thanks for the feedback guys! Doing the char(13) thing worked eg. INSERT INTO Table1 (col1) SELECT 'See Original Order comments below' + CHAR(13) + CHAR(10) + col1 AS col1 FROM Table1 WHERE col2 = something Thanks Again, David.
  2. Rabbitfood

    Select vbCRLF as part of a string for Insert

    I stand corrected! I handnt actually tried that, I tried "select 'Line' + vbCRLF + 'wrap'" which is obviously not going to work. I will test and confirm that "select 'Line' + CHAR(13) + CHAR(13) + 'wrap'" works as expected. Thanks, David.
  3. Rabbitfood

    Select vbCRLF as part of a string for Insert

    I have been using vbCRLF in the past and it does what I need. The purpose of the query I am trying to create is to post my data in one hit without first having to retrieve the data then format it and post it back. I believe I would experience the same problems with trying to use CHAR(13) +...
  4. Rabbitfood

    Select vbCRLF as part of a string for Insert

    Hi, I am trying to do a select into ie. INSERT INTO TableA (col1, col2) SELECT (col1, col2) FROM TableA WHERE col3 = ... Now in part of my select statement I want to create a new string by selecting some existing data and building it up using the + operater but I also want to include vbCRLF...

Part and Inventory Search

Back
Top