if the format is always last name, first name you can use STRSTR to find the comma and set a variable then use SUBSTR and the variable created to parse the field with 2 set fields actions into the other 2 fields.
-----Original Message-----
From: [EMAIL PROTECTED]
To: [email protected]
Sent: Wed, 11 Oct 2006 11:35 AM
Subject: Parsing a Field
If you have a character field that contains a full name (Ex: "Smith, John"), how could you parse it so that you could set a Last Name field with "Smith" and a First Name field with "John"? Thanks! Carol ARS 5.1.2 SQL Server _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
