>>>Is there an obvious way to eliminate the last four characters of a string variable? Like somehow use the RIGHT() function? The number of characters of the string vary, but the string always has the same four characters at the end. Like an extension.
>>>
>>>Thanks for putting up with newbie questions.
>>
>>lcString = LEFT(lcString, LEN(ALLTRIM(lcString))-4)
>>
>>or, if you know exactly what those characters are (say,"ABCD") and they are not repeated anywhere else in a string:
>>
>>STRTRAN(lcString, "ABCD", "")
>
>Nick,
>
>Everyone has answered LEFT(....
>
>What's wrong with SUBSTR(...?
I think LEFT is faster.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer