SQL select/NULL question

action_owl · 12-23-2010, 01:22 PM

If I have a Query that returns columns where some of the values are NULL, is it possible to tell SQL to return all the NULL values as empty strings instead of the NULL datatype?

If the solution is vendor specific I am (unfortunately) using a Microsoft 2008 SQL server.

Example:

Code:

Select * from imaginary_table where id = 1

Might return:

Code:

Id: 	1
Name:	xyz
Value: 	this
Etc: 	NULL
Stuff: 	NULL

But what I would want it to return is:

Code:

Id: 	1
Name:	xyz
Value: 	this
Etc: 	
Stuff:

Tinkster · 12-23-2010, 01:31 PM

Let me google this for you ...

Funnily enough the first 4 links are references to T-SQL,
the MS products dialect ;}

Cheers,
Tink

paulsm4 · 12-23-2010, 07:18 PM

Quote:

Funnily enough the first 4 links are references to T-SQL,
the MS products dialect ;}

The "select case" technique is probably the one I'd choose...

BenCollver · 12-23-2010, 08:24 PM

I like coalesce.