How to compare for numeric value in 6 pos of 10 pos field

The selection critieria in a view I am creating must look for numerics in the 6 position of a 10 position field (the field is A/N). What is the best way to do this? thanks

Subject: How to compare for numeric value in 6 pos of 10 pos field

Dennis,

Do you mean something like this?

SELECT @Matches(@Subset(@Subset(AN; 6); -1); {0-9})

regards,

raphael

Subject: RE: How to compare for numeric value in 6 pos of 10 pos field

yes, but how does this work… I do not see my field name anywhere so where does it fit in…