This is what I currently have, I have left out the rest because it is too long. I am wondering if there is any way that I can do an inline string replacement. I would like to be able to replace the number "1" in "survey.question1_abbreviation" with a parameter value. Is this possible?? SELECT comp.company_name , 1 question_number , count(distinct cl.log_id) AS survey_count , survey.question1_abbreviation AS question , survey.question_1 AS questionAbbr , sum(IF(answer.answer_1 IN ('Yes','Very I would like: survey.question$P{number}_abbreviation Post edited by: jmoll26, at: 2006/10/03 22:18