check field

[MauriceLudo]

Hi,

I try to test A_B_C

if A = Num '0000' and B = 'FR', 1, 0



thank you in advance
Best regards
Maurice

[m_woolf]

if(A = 0 and B = 'FR', 1, 0) as WhatEver

[PabloTrevisan]

Could you explain more?

[m_woolf]

Not without seeing your data and having a better understanding of what you are after.

All I did is write your statement using correct QV syntax.

[PabloTrevisan]

Yes, I asked him if he can explain better than he wishes.

[m_woolf]

Sorry Pablo. I confused you with Maurice.

[MauriceLudo]

A = A is a numerical 4 digit

B equal FR

[balabhaskarqlik]

May be like this:

If(Len(A)=4 and B = 'FR', 1, 0)

[MarcoWedel]

-(IsNum(A) and Len(A)=4 and B='FR) as SomeFieldName