how modify field so that only part of text string appears

[leeroi]

I have a query that display clients first and last names in two separate fields. I want to modify it so that it displays only the first letter of the first name in the FirstName field.

How can I do this?

Thanks

 

[rjoubert]

SELECT Left([FirstNameField], 1) FROM YourTable

 

[PJ44]

Likewise, you can use the RIGHT function to select characters on the right side of your string. This obviously dosen't apply to your situation, but still good to know.

Left(field name or string,#)
Right(field name or string,#)

# equals the number of characters you want to see. So if you want the last 3 characters of a model number for example...

SELECT Right([ModelNum],3) FROM tblComponents

Hope this helps!
PJ

 

[lespaul]

and if you want something in the middle, it's MID:

MID(FieldName, WhereToStart, HowFarToGo)

MID("Programmer", 3, 5) would return:

ogram



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[leeroi]

Thank you.

Lee