k.allen.emt (1/25/2015)

---

Phil,

=) sorry, thanks I will give it a shot.

Beyond new here in this, my buddy tossed me his MySQL book "The Language of SQL" and said read.

Thank you again... also I was a bit lost on trying to obtain data for you guys with

SELECT 'SELECT '

+ QUOTENAME(ID,'''')+','

+ QUOTENAME(phone_number,'''')+','

+ QUOTENAME(first_name,'''')+','

+ QUOTENAME(last_name,'''')+','

+ QUOTENAME(address1,'''')+','

+ QUOTENAME(address2,'''')+','

+ QUOTENAME(address3,'''')+','

+ QUOTENAME(city,'''')+','

+ QUOTENAME(state,'''')+','

+ QUOTENAME(postal_code,'''')+','

+ QUOTENAME(HOME_OWNR,'''')+','

+ QUOTENAME(HH_INCOME,'''')+','

+ QUOTENAME(CREDIT_RATING,'''')+','

+ QUOTENAME(AGE,'''')+','

+ QUOTENAME(source_id,'''')+','

+ QUOTENAME(title,'''')+','

+ QUOTENAME(comments,'''')+','

+ QUOTENAME(dnc_flag,'''')+','

+ QUOTENAME(provider,'''')+','

+ QUOTENAME(vehicle,'''')+','

+ QUOTENAME(coverage,'''')+','

+ QUOTENAME(alt_phone,'''')+','

+ QUOTENAME(email,'''')+','

+ QUOTENAME(marital_status,'''')+','

+ QUOTENAME(dob,'''')

+ ' UNION ALL'

FROM leads

Running that reports:

[Err] 1305 - FUNCTION leaddb.QUOTENAME does not exist