Testing for a numbers stored Char(18) field

chulett · Post by **chulett** » Thu Sep 25, 2008 10:25 am

Perhaps...

DIGITS(in.FldName) = in.FldName And in.FldName < 1000000

tbtcust · Post by **tbtcust** » Thu Sep 25, 2008 10:35 am

Apologies chulett. This should have been posted to the Parallel job forum. I'll repost there. Thanks.

chulett · Post by **chulett** » Thu Sep 25, 2008 10:51 am

This *is* the Parallel job forum.

Just edit the original post and change the job type.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 25, 2008 3:17 pm

With what character are the Char(18) fields padded?

tbtcust · Post by **tbtcust** » Fri Sep 26, 2008 3:45 am

Sorry about the confusion chulett

ray.wurlod , the field is padded with spaces. The number sometimes has a leading zero or two.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 26, 2008 4:38 am

Compare the trimmed strings. If that alone doesn't work is the Compare() function available? (I'm not on site right now.)

tbtcust · Post by **tbtcust** » Fri Sep 26, 2008 10:03 am

I got the same results with Compare ray.wurlod.

NUM(Trim(in.field)) = 1 And Len(Trim(in.field)) < 7 seems to work. Not so pleased with this workaround but hey it does seem to give me what I need.