[RESOLVED] Get Users Account Logon Info

Hi,
Sorry for asking this because I know its on here somewhere but cant seems to find it when I search.

All I want is an SP that returns my logon name i.e jsmith

but cannot remember the exact syntax.

Found it

select system_user as my_user_name

Returns full domain/username

Anyone know how to strip out the domain si it just returns the username?

Used Substring