RRW 8.0 XBase: Special Characters

[Matt_Kiley_(Guest)]

To whom it may concern:____I am interested in where the special characters come from and if I understand the true meaning. __ Examples - __CHKDED->CODE$"940,941,942,943,944,945,946,948,952,953" indicates that in the CHKDED database the field CODE is in the list "940,941,etc".____Should CHKDED->CODE#"940,941,942,943,944,945,946,948,952,953" indicate that in the CHKDED d/b the field CODE is NOT in the list? ____Thank you.__Matt.

[kfleming]

CHKDED->CODE$"940,941,942,943,944,945,946,948,952,953" __does indicates that in the CHKDED database the field CODE is in __the list and would be true for codes 1,2,3,94,40,46 as well so you need to consider that as well.____You could alternatively use:__INLIST(CHKDED->CODE,"940","941","942","943","944","945","946","948","952","953")>0__to test explicitly for this list of values__or __INLIST(CHKDED->CODE,"940","941","942","943","944","945","946","948","952","953")=0__to determine that the current value is not one of these.____Kathleen__R&R Support

[Matt_Kiley_(Guest)]

Thank you. Your ^tip^ below helped.____PS - Those that read this should be aware that using >0 at the end of the INLIST() function will change it from a numeric to a logic field (T/F).____Sincerely,__matthew_kiley@dell.com