Very Computer

Problem with select

Here is the code
SELECT First + ' ' + Second + ' ' + Third AS CollegeName FROM copiedcolleges

All first columns have something in them.  A majority of the Second columns
have somthing in them.  A very select few have something in Third column.

This query will only return rows with something in all columns.  If only is
something in the First and Second columns the value will be <Null>.

I'm really trying to bring these three fields into one fields.

TIA

Mike

I'm not sure I fully  understand the problem you're having.

But I suspect you're seeing the defined ANSI beavior that 'string' = NULL =
NULL.

To avoid this, could use COALESCE(Second, '')

COALESE returns the first non NULL value from an enumerated list.

So you would end up with 'string' + '' which = 'string'

Brian Moran

Quote:> Problem with select

> Here is the code
> SELECT First + ' ' + Second + ' ' + Third AS CollegeName FROM
copiedcolleges

> All first columns have something in them.  A majority of the Second
columns
> have somthing in them.  A very select few have something in Third column.

> This query will only return rows with something in all columns.  If only
is
> something in the First and Second columns the value will be <Null>.

> I'm really trying to bring these three fields into one fields.

> TIA

> Mike