< snip >
>
lcFilter = [NOT EMPTY( CHRTRAN( Amenities, &cValidAmenities, " "))]
>
>
>Can I put this modified expression in a table? cValidAmenities would be a global string.
I think you can but you'll have to modify it a little bit
lcFilter = [NOT EMPTY( CHRTRAN( Amenities, "&cValidAmenities", ""))]
>Lookups tables rarely get updated (almost never), so instead of using cValidAmenities string I can explicitly put the values.
It's dangerous because at some time it could change and nobody would remember that the filter expression has to be changed also.
>
< snip >
--sb--