Re: substring

["Cadenas, Maria (MT)" <MCadenas@DOW.COM>]

thanks
-----Original Message-----
From: Lu, Clint [mailto:clint.lu@CAREMARK.COM]
Sent: Thursday, February 15, 2001 12:03 PM
To: SQR-USERS@list.iex.net
Subject: Re: substring


First move &name to $name and separate $LastName, $FirstName and $MidInitial
by using Rotate-Name procedure from rotname3.sqc then you can substring only
the first six letters of Last Name only. For your example below, the last
name will LEE only not LEE, J.

Hopes this help.


Clint Lu
Sr. Programmer/Analyst
Caremark Rx, Inc.
Phone: (847) 559-4717
Fax    : (847) 559-4840


-----Original Message-----
From: Cadenas, Maria (MT) [mailto:MCadenas@DOW.COM]
Sent: Thursday, February 15, 2001 10:34 AM
To: SQR-USERS@list.iex.net
Subject: substring


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.