http://support.microsoft.com/support/kb/articles/Q247/4/94.ASP>>I only use the ALLTRIM(STR()) format when I know I'm dealing with integers. If I have decimals, I pass the extra parameters to STR() that specify the number of decimals. I'm kind of leary of switching to TRANSFORM() after reading the Knowledge Base article I mentioned previously. Did you take a look at that?
>
>Not yet, since you didn't provide a convenient link (I'm a lazy person), but I'm doing right now...
>>
>>>>Is there any particular reason why you use TRANSFORM() instead of ALLTRIM(STR())? I just searched the MS Knowledge Base and found the following article that mentions some problems with TRANSFORM(): Q247494. I've just always used ALLTRIM(STR()), and never really looked at anything else, so I didn't know if there was a benefit to using TRANSFORM() other than less typing.
>>>
>>>One function instead of two, and also look to the difference between:
>>>lnNumber=2.345678901
>>>?transform(lnNumber)
>>>?alltrim(str(lnNumber))
>>>
>>>>>>There may be a better way, but of the top of my head:
>>>>>>
>>>>>>ALLTRIM(STR(VAL( LEFT( oJC.IssMonth, 2 ) )))
>>>>>
>>>>>Hi Jonathan,
>>>>>
>>>>>With VFP6.0 I make a habit to use transform() instead of alltrim(str())
>>>>>
>>>>>
>>>>>>>Hi everybody,
>>>>>>>
>>>>>>>I have this string in my report:
>>>>>>>SUBSTR(oJC.IssMonth,3) +' YEAR-TO-DATE RECAP THRU ISSUE ' +LEFT(oJC.IssMonth,2)
>>>>>>>
>>>>>>>left(oJC.IssMonth,2) would be '07', '08', etc. I would like to print just '7' or '8' in my Report. What would be the simplest way to achive this?
>>>>>>>
>>>>>>>Thanks.