First letter of a string

Yahoo Archive
1
In what software?

Crystal and Access: left([fieldname],1)
Report Builder: SUBSTRING([fieldname],1,1)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Wednesday, August 01, 2007 11:30 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] First letter of a string

How do you create a calculated field that will trim a person's last name
so it will only show the first letter of their last name?

Thanks,
Jasper



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
2
How do you create a calculated field that will trim a person's last name so it will only show the first letter of their last name?

Thanks,
Jasper



[Non-text portions of this message have been removed]