by searching, I found this one: thread131-1439275 which got just the last part of an e-mail address.
I adjusted part of the formula and got to just the first part (the individual's name) by using:
SUBSTRING(PS_PERSONAL_DATA.EMAIL_ADDRESS,1,CHARINDEX('@',PS_PERSONAL_DATA.EMAIL_ADDRESS))
the result I got is now: JSMITH@
It's close and most definitely workable, but I just wondered how I could clean it up further to remove the "@" to leave just: JSMITH
ThanX !
I adjusted part of the formula and got to just the first part (the individual's name) by using:
SUBSTRING(PS_PERSONAL_DATA.EMAIL_ADDRESS,1,CHARINDEX('@',PS_PERSONAL_DATA.EMAIL_ADDRESS))
the result I got is now: JSMITH@
It's close and most definitely workable, but I just wondered how I could clean it up further to remove the "@" to leave just: JSMITH
ThanX !