left("%username%",8)

or using the macro in kix
left(@userid,8)
_________________________
(... better days ahead)