I need to put FirName initial with LastName 1

[WB786]

I can't figure out how to update a field with firstname initial and lastname in that field. I know how to use the Trim function and putting two fields togather but figure out how to take the first letter of the first name and the whole last name.

Thanks!

WB

 

[PHV]

Have a look at the Left function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[postmanphat]

SELECT Left(firstname,1) FROM tablename

will give you inital

 

[WB786]

POSTMANPHAT THANKS!

Sometime when my brain goes dead I come here! You guys are awsome!

WB