title: Replace value in result by a specific value
body: <p>I need to make a query to collect some data from a database via SQL. In this data there is 1 value used as collection value. This are ID's of courses given. Sometimes a course can be given about f.e. Office. But people can do a course there for word, excel, powerpoint... But this is all given in 1 course by 1 tutor. Still for statistics I need to know if they participated the course for Word, Excel, Powerpoint ...</p>
  
  <p>Is it possible to replace values in the resultset? With this i mean something like this:</p>
  
  <p>if value = courseValue ==> replace value with specific courseValue (I can get the value via a subquery)</p>
  
  <p>I hope this makes my problem clear and i appriciate all the help!</p>