Hellos.

Just to save my sanity and having to change my custom function

I need to set initial passwords on a new AD account depending on their unit. I have the IIF constructed but it simply tests the MV attribute with a fixed string.

e.g.

IIF(Eq(ToimialaNimi,"SOTET"),"SOTETpwd",

IIF(Eq(ToimialaNimi,"PALI"),"PALIpwd",

IIF(Eq(ToimialaNimi,"TYT"),"TYTpwd",

IIF(Eq(ToimialaNimi,"KEHA"),"KEHApwd","SITOpwd"))))

would this statement catch ToimialaNimi values like sotet Sotet SOteT Pali PALI PalI etc.. or *must* I plug in the Uppercase function (does it exist?) before each ToimialaNimi

like IIF(Eq(Upper(ToimialaNimi),"SOTET"),"SOTETpwd",  and so on.....

I prefer not to use the Uppering function if I can get away with it.

*HH

No. It will not catch them. You need uppercase.

You can always test