Jay, See the article "Parsing - or the Art of Pulling Things Apart" at http://custom-software.biz/AccessWizard/Dec04.htm.
Gary At 05:15 PM 12/17/2008, you wrote: >Help wanted: separate a full name string with comma in string into >first name and last name. > >Need a query statement that will parse a [FULL NAME] field >containing "last,first" name into a two other field [fisrt] and [last] >in the same table. > >Thanks and Happy Holidays >Jay > >
