|Subject||Re: [firebird-support] Re: Cast( float as varchar(20) ) formatting?|
|Author||Ann W. Harrison|
> Thank you both for your prompt replies.Do watch out that you don't turn 100 into 1.
> Sounds like the ticket is:
> trim( both '0' FROM cast( NumField as varchar(20) ) )