strings

[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

 

[Brendan Reynolds \(MVP\)]

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.