<p>How do I return a constant from an sql statement? </p>

<p>For example how would I change the code below so "my message" would return if my (boolean expression) was true</p>

<pre><code>if (my boolean expression)
 "my message"
else
 select top 1 name from people;
</code></pre>

<p>I am using ms sql 2000</p>

Did you try:
```
```
select 'my message';
```
```