Search results

Thx guys (: i've found the solution UCASE(IIF(InStr([Richting],"-"),LEFT([Richting],1)+MED([Richting],InStr([Richting],"-")+1,1),LEFT([Richting],2))) as AFK :)

We had an exercice for school: we have to create a function that has this as a result: name,show: handel: HA Handel-talen: HT Secretariaat-talen: ST boekhouden-informatica: BI if there is no "-" then only the first two letters, else the first letter, and the first letter after the "-" These...