>How to get the first 5 numbers of a numeric expression
>
>
> ex: 754341232323232
>
> 75434
>
>
> Thanks
>
> Moises
left(transform(754341232323232),5) will return a character exopression. if you want to turn that back into a numeric, add the VAL() function around it.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao