The studio drill-down wizard is generating SQL code that has a where clause like:
Members.First LIKE '%%' AND Members.Last LIKE '%#lastname#%' AND Members.Company LIKE '%%' AND Members.City LIKE '%%' AND Members.State LIKE '%%' AND Members.Country LIKE '%%' AND Members.MemberType LIKE '%%' I am not getting the results that I expected to get. What exactly does a condition: field like '%%' actually filter on? Rick Colman ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists