>How do I remove leading zero's in a report??
>
>I have a field on my report named Task ID which looks like the following:
>
>000911
>000912
>000913
>
>I want it to report like:
>
>911
>912
>913
>
>any help would be much appreciated
ltrim(str(val(TaskID)))
or:
trans(val(TaskID))
or:
Directly when creating your report cursor :
select val(tAskID) as TaskID ..
Cetin