Cast string to number

[#1]

Hi

I am trying to cast a string to number, the string is formated as this. 0000000000000234.

I am trying usign num function but doesn't work. I need to get the 234 only.

Thanks in advance

[chematos · Accepted solution]

Try this to discard zeros

replace(LTrim(Replace(Field, 0,' ')), ' ',0)