Originally posted by comatt1
(if LENGTH({?DescWildcard}) - LENGTH(REPLACE({?DescWildcard}, ',', ''))=LENGTH({?DescWildcard}) then
lowercase({POIT.Description}) = {?DescWildcard} else
lowercase({POIT.Description}) in [{?DescWildcard}])
if they delineate with commas this should work
this works with a single parm, if descwildcard always will be matt,been,grease
it will work
(if LENGTH({?DescWildcard}) - LENGTH(replace(REPLACE({?DescWildcard}, ',', ''),' ','*'))=LENGTH({?DescWildcard}) then
lowercase({POIT.Description}) = {?DescWildcard} else
lowercase({POIT.Description}) in [{?DescWildcard}])
I think this may work
Edited by comatt1 - 14 Nov 2012 at 11:10am