hi,
If your answer yes ?NO
In other case you can to do A PARSE and look for a first number and substract it.? I HAVE NO IDEA
THANKS.
>Hi Mohammed,
>Are your three first positions letter forever and the number begin in the fourth position?
>If your answer yes so you can to do it:
>
>lnSticket = Val(SubStr(Sticket, 4))
>lnEticket = Val(SubStr(Eticket, 4))
>
>In other case you can to do a parse and look for a first number and substract it.
>Good luck!
>
>
>>hi all,
>>any idea, help
>>>Sticket=ABC100 CHAR TYPE
>>Eticket=abc40 CHAR TYPE
>>NOOFTICKET NUMARIC TYPE
>>NOOFTICKET= Sticket- Eticket=60
>
>>THANKS
>