Seperate Name?

[Ielamrani]

Hi,
I would like help on how to seperate Full Name to Last and First.

Example:

Full Name: NEJAT, MICHAEL

I want The query to show:

Last Name: NEJAT
First Name: MICHAEL

THANKS IN ADVANCE

iSMAIL

 

[SkipVought]

Hi,

Select Right([Full Name],Len([Full Name])-inStr([Full Name],",")) As First, Left([Full Name],inStr([Full Name],",")-1) As Last, ...

Skip,

_{[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE}

 

[Ielamrani]

Great. Thank you very much.

Ismail