Simple select question!

[DBC User]

Hi,

I feel so stupid to ask this question, but here it goes

When I select a column from a table, if the column has a null value I
want the select to return me a blank. I have done this before but I
forgot, some one help?

select name, age from people

in the above query the name can be null. I do not want to do

select @name=name....

Thanks.

[David Portas]

COALESCE(name,'')

--
David Portas
SQL Server MVP
--

[John Gilson]

"DBC User" <ks*****@yahoo.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

Hi,

I feel so stupid to ask this question, but here it goes

When I select a column from a table, if the column has a null value I
want the select to return me a blank. I have done this before but I
forgot, some one help?

select name, age from people

in the above query the name can be null. I do not want to do

select @name=name....

Thanks.

Use the COALESCE function, e.g.,

SELECT COALESCE(name, ' '), age
FROM People

--
JAG

[Andy Williams]

DBC User,

Is this what you mean?

SELECT CASE WHEN [Name] IS NULL THEN '' ELSE [Name] END AS [Name], Age FROM
People

btw, don't use 'Name' as a column name, it is a reserved word in SQL.

-Andy

"DBC User" <ks*****@yahoo.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

Hi,

I feel so stupid to ask this question, but here it goes

When I select a column from a table, if the column has a null value I
want the select to return me a blank. I have done this before but I
forgot, some one help?

select name, age from people

in the above query the name can be null. I do not want to do

select @name=name....

Thanks.

[DBC User]

Thanks all for the answer. I was looking for COALESCE