Jump to content

Advanced SQL Help Needed


Recommended Posts

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




, 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

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...