strings

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
 
B

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.
 
Top