Set default value for datacolumn in select statement

Question

I want to assign default values ​​to a column in my sql select query so that if the value of this column is null, I get this default value in my recordset. Is there any way to do this?

Example:

select col1 (some default value) from tblname; 

Answer 1

The preferred way is to use the ANSI-compliant COALESCE function:

 SELECT COALESCE(column_name, default_value) FROM table_name; 

You can also read an article that compares COALESCE and ISNULL .

Answer 2

 select isnull(col1, defaultvalue) from tblname; 

Answer 3

if you use SqlServer you can use the CASE statement

Example:

select register col1 when null and then defaultval else col1 termination with tblname

where defaultval is the default value. The defaultval data type must match the col1 data type.