<p>I want to assign default values to a column in my select sql query so that if the value of that column is null I get that default value in my recordset.  Is there anyway to do this?</p>

<p>Example:</p>

<pre><code>select col1 (some default value) from tblname;
</code></pre>

```
```
select
  isnull(col1, defaultvalue)
from
  tblname;
```
```