INLIST using $

[txgeekgirl1]

I am trying to do a "macro substitution" type thing and have some pretty long Where clauses.

I am trying to shorten them by using something like this:

lcfilter = "LEFT(svccode, 3) <> '103' ;"
lcfilter = lcfilter + "and LEFT(svccode, 3) <> '207' "
lcfilter = lcfilter + "and LEFT(svccode, 6)!$('1102AM', '1102BM','2102AM','2102BM'")

Does anyone know the rule for using a NOT before the $. Should it be a <> or something else?

 

[Mike Lewis]

Glad to see you've got it working, Txgeekgirl1. Don't forget to drop by again next time you have a problem.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business