strings

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi,


I have a table with FirstName, Last Name colomns


FirstName LastName
Joe J Smith
Jay J Fisher
David D Epstein

How can I get rid of the middle initial from the
FirstName?
Thanks for your help.
Jen
 
SELECT Left$([FirstName],InStr([FirstName]," ")-1) AS NameFirst
FROM tblTest;

Watch out for records with two-word first names, e.g. John Joe, Billy Bob,
Sarah Jane.
 
Back
Top