RE: [ cf-dev ] Monday Morning SQL question

[Peter Harrison]

Hi   Yes, Monday is bad, even for me.   Here's an example I made with your tables and fields:   UPDATE    contact SET              address = address1 + CHAR(10) + address2 + CHAR(10) + city + CHAR(10) + postcode + CHAR(10) +                           (SELECT     state                             FROM          state                             WHERE      state.state_id = contact.state_id)   It's shoddy syntax, so please make corrections. But you get the idea.   - Peter -----Original Message----- From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: 17 May 2004 07:51 To: CF - List Subject: [ cf-dev ] Monday Morning SQL question Brain not awake yet, so i thought i would see if anyone has one that is.   I have a table with address1, address2, city, postcode, state (state related by id to a table of us states). I have created another column called address where i want to put these 5 pieces of data separated by chr(10).   How can I do this ONLY using sql not cf?     Thanks Allan                 -------------------------------------------------------------- Allan Cliff Malaga RedPro S.L. --------------------------------------------------------------