| Subject | Re: [firebird-support] Re: Cast( float as varchar(20) ) formatting? |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2010-07-09T15:14:55Z |
bwc3068 wrote:
Cheers,
Ann
> 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) ) )
>
Cheers,
Ann