[ cf-dev ] Monday Morning SQL question

[Allan Cliff - CFUG Spain]

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. --------------------------------------------------------------