[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: substring
Maria,
If you are using personal_data, just use the field LASTNAME instead
of NAME. LASTNAME is all in capital letters, otherwise you can use
the ROTNAME sqc.
>From: "Cadenas, Maria (MT)" <MCadenas@DOW.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: substring
>Date: Thu, 15 Feb 2001 11:33:36 -0500
>
>we need to select the first six letters of a last name for each employee,
>however, the format for the field is:
>Last, First Middle (i.e. Lee, James G)
>
>Is there a way to make sure we substring only the first six letters of ONLY
>the last name? so that if the last name is three digits (i.e Lee) we ONLY
>get Lee and NOT Lee, J?
>
>Any advice is appreciated.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com