If dont wildmatch

[#1]

Hi everybody,

I want to know how i can do if dont wildmatch

Here my example : i want to have 1,7 as Seuil_Z1 if [Clients Emeraude] <> '0'

if(WildMatch([Clients Emeraude 1],<>'0'),'1,7') as Seuil_Z1,

If someone have a reponse.

Thanks

[datanibbler]

Hi feneman,

if I understand correctly your requirement, you just want to query if the field [Clients Emeraude] has some value other than 0.

You don't need a WildMatch to do that, though. A simple IF() query will suffice for that.

(you'd need WildMatch to find out whether that field has one of n particular values)

HTH

Best regards,

DataNibbler

[maxgro · Accepted solution]

you can use not

if(not WildMatch([Clients Emeraude 1],'0'),'1,7') as Seuil_Z1,

but i think is better

if([Clients Emeraude] <> '0', 'something', 'something else')  as .......

[sasiparupudi1]

try

if([Clients Emeraude 1]<>'0' and WildMatch([Clients Emeraude 1],'1,7')>0,[Clients Emeraude 1],0)

[#5]

Thanks you guys.