jmoll26 Posted October 4, 2006 Share Posted October 4, 2006 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?? SELECTcomp.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}_abbreviationPost edited by: jmoll26, at: 2006/10/03 22:18 Link to comment Share on other sites More sharing options...
lucianc Posted October 4, 2006 Share Posted October 4, 2006 You can do survey.question$P!{number}_abbreviation. HTH,Lucian Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now