IF Statement ......... Help!

[Azita79]

Hi All,

My tblclient has both individual clients and company clients data

It has the following data

Pkclient
FirstName
LastName
CompanyName
Etc …

I want to select the companyName if there is one, otherwise select FirstName and LastName.

Here is my Pseudocode: If CompanyName is not null then select companyName
Else select (Firstname & ‘ ‘ & LastName)

But I don’t know how to write the IF statement in SQL

Any help would be greatly appreciated

Azita

 

[sunila7]

Hi,

U can do something like this

Select Isnull(CompanyName, FirstName + ' ' + LastName) From TBL

Or
Select Case CompnayName when NULL then FirstName + ' ' + LastName Else CompanyName End from TBL



Sunil