>>>>Kindly double check: STR(-1*VAL(ALLTRIM(your_char_field))) always returns
>>>0. I appreciate the idea.
>>>
>>>? STR(-1*VAL(ALLTRIM(" 500 "))) returns "-500" for me.
>>
>>No. What I mean is purely character... say CustomerID is "UPI". Anyway case to case basis maybe. Still, the idea is there.
>
>Jess, the "-" character can be added to any character field - same idea as multiplying a numeric field by (-1)
ohh yea... concatenate "-" to the character field??
Actually the idea is good only for one deletion, otherwise, two or above makes the difference.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."