Negative values with sign

[YanivZi]

I am loading  some values that are formed like that: '-0000000151515' and some like this '0000000151515'.

The values with the minus sign are interpreted in the model like this: 151515M (and sometimes other capital letters)

I like to do this:

1. Remove leading zeros 
2. Keep the minus if exists

I've tried

Num#(Sample, '0;0-') as Amount2

 but it did not worked 

[luizcdepaula]

Hi Yaniv,

If you don't have decimals with 0 before the decimal separator, the below should work.

REPLACE(num(LTRIM(REPLACE(Sample, '0',' '))),' ', '0') 

Cheers,

Luiz

[Aurelien_Martinez · Accepted solution]

Hi,

If you try 

Sample*1 as Sample

Aurélien 

[YanivZi]

Both answers were right! but @Aurelien_Martinez  solution was very simple and do the same job.