0000012345.23 TO 12345.23?

[UBfoolin]

It seems CAST() can only convert to integers. How can I strip the leading zeros from a varchar field?

If I use FORMAT("0000012345.23",2), I get 12,345.23 which would be great if I could stop the comma 1,000s separator.

How can I get the result I want, 12345.23?

Thanks,
Dan

 

[r937]

trim(leading '0' from myvarchar)

r937.com | rudy.ca

 

[UBfoolin]

Thank you! Worked great!