Show record only with specific numeric length

Printed From: Crystal Reports Book — Forum Name: Technical Questions

I have a Numeric field that have 5-12 numbers. Is there a formula to only show the record that have either more than 12 numbers or maybe even from 6-no number?

Example: {numeric.field}<=6 (disregarding the 0's)

000000001234
003343455423
433444435544
000000003456

It should show only

000000001234
000000003456

Thanks!
It appears you have a string with numeric characters and you want to know which of these, when read as a number is <1,000,000.
Try and convert the string to a number and use that logic

tonumber({table.field})<=999999