I am Creating a report in Crystal Reports where we have blanket work orders 100-999 that we do not want to show. We just want to show just the results for work orders 1000+. Normally we would get results greater than 1000 but because its a string field in Cityworks it puts number in order regardless of number of characters. example 1000,1001,101,1010,102,1020,1021,1023,103, etc.. 101,102,103 should not be in the results. So I am looking for a code to eliminate 3 character results.
Thanks for any help with this.