change expressions to yes/no

[#1]

Dear,

From my qvd I load many customers. Some of the customers have a number, others not. I want to show in my chart if a customer has this number, with a "Yes".

Load from QVD:

Customer       Number   

A                    9876543213

B                    2135743518

C

D              

E                    3486135464

I want to show:

Customer     Number

A                  Yes

B                  Yes

C                  No

D                  No

E                  Yes

I hope this is possible.

thanks a lot!

Best Regards,

Sander

[alexandros17 · Accepted solution]

Load

customer,

if(Len(NUmber)>0,'Yes','No') as Number

from

....

let me know

[#3]

It can also be done using

if(isnull(Number),'No','Yes') as Number

[#4]

Perfect!

thanks a lot!