Re: [cf-dev] RE: [ cf-dev ] Monday Morning SQL question

[Allan Cliff - CFUG Spain]

Thanks. ----- Original Message ----- From: Peter Harrison To: [EMAIL PROTECTED] Sent: Monday, May 17, 2004 10:01 AM Subject: [cf-dev] RE: [ cf-dev ] Monday Morning SQL question 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. --------------------------------------------------------------