> C.LASTNAME || ', ' || C.FIRSTNAME || COALESCE(' ' || C.MIDDLENAME, '') AS
> NAME,>>
>
> Magnus the Magnificent!

In addition to Magnus' answer...

If you don't want "middlename" to be "unknown" (because you DO know the
middle name is ''), then just store '' and not NULL.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com