Revise iif expressions to SSMS 1

[ciarra41]

I normally run this in Access but now I need to do the same thing using SSMS-Express. However it’s a little different. Could someone revise this two to do the same thing?

IIf(IsNull([mytable.acttnum]),"",[[tn_npa] & "" & [tncop] & "" & [tnline])
and
customerUCase([FIRST_NAME]) & " " & UCase([LAST_NAME]))

 

[nickdel]

You need to use a case statement, I'm not very clued up on SSMS-Express but I'm pretty sure it supports it!

 

[r937]

case when mytable.acttnum is null
then ''
else tn_npa + '' + tncop + '' + tnline
end

UPPER(FIRST_NAME) + ' ' + UPPER(LAST_NAME]) AS customer

r937.com | rudy.ca

 

[ciarra41]

Hi r9387
On your first example I'm not sure where to put this.

 

[r937]

in the query, in the SQL source for the query

r937.com | rudy.ca

 

[ciarra41]

Sorry for the trouble, I got it!