Sql server display string in when statement <p>I have the following query</p> <pre><code>select (case when object like'%service%' then (object) when class like '%service%' then (class)end) From db group by (case when object like '%service%' then object when object_class like '%service%' then object_class end) </code></pre> <p>this query check if value of each column contains 'service' than display the data, i need instead of data only display, data and string<br/> Some thing like <code>when object like'%service%' then (object),'string'</code></p> <p>String will be a variable which is stored in unknown column at results </p> <ol> <li>column1 column2</li> <li>objet1 mystring</li> <li>objet2 mystring</li> <li>objet3 mystring</li> </ol>