Re: Select Statement

From: Steve Kass (skass_at_drew.edu)
Date: 05/14/04 

Date: Fri, 14 May 2004 16:30:47 -0400

select
  coalesce(CompanyName, LastName + FirstName) as theName
from T

or

select
  case when CompanyName is null
  then LastName + FirstName
  else CompanyName end as theName
from T

Steve Kass
Drew University

KK wrote:

>This is regarding a SQL Select statement
>I have a table with 3 columns First Name, Last Name ,
>CompanyName
>I want a result of companyName, using a select statement
>with the condition that
>if CompanyName is Null then result should have LastName +
>FirstName
>
>something like
>if CompanyName is null Then
>Select LastName + FirstName from Table
>else
>Select CompanyName from Table
>
>Can this if..else be used in a single Select statement?
>
>