I want to match and replace all that starts and ends with "driver" to "DRIVER"

[Qlikuser09]

Load

"JOB" AS [Position ]
, If(
WildMatch([JOB],'*DRIVER*', 'Driver')
,[JOB]) as [Position1]

I have Positions as "motorcycle driver", MVC driver, MTR driver, i want to replace everything and name them as "DRIVER" when data load.

[JuanGerardo]

Why not use Replace():

Load
   "JOB" AS [Position ],
   Replace([JOB], 'Driver', 'DRIVER') as [Position1]

 JG

[MarcoWedel]

If(WildMatch(JOB,'*DRIVER*'),'DRIVER',JOB) as Position1