>One more complication for Amenities field - this field is 10 char long and it's a concatenation of codes, e.g. ABCUD, where each letter is a code. How would we filter those contain incorrect codes?
For this one, I don't know a simpler alternative than to use a FOR loop.
local i
for i = 1 to len(amenities)
if not substr(Amenities, i, 1) $ "ABCDE"
return .F.
endif
next
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)