Tips and Hints

Someone had a question on how to delete leading 0s from a character field such as having the following info:

0123345 3476534 2343255 0023478

If the character contains only numeric information then you can change the field to numeric through the field manipulation.  You probably want to look through it after to make sure there are no errors which could indicate that there is also character data.

If you want to keep the original field you can append a new numeric field and use the @val function on the other field.

If it contains both numeric and alpha numeric