# 1149 TEXTSEARCH SQL and Filter Function Not Working Properly with Asterisks for Wildcards in Words

---

I'm experimenting with Textsearch as a filter. Using as an example The Weston Democratic Club, I have found that the following get a hit:

Filter := 'TEXTSEARCH("democratic weston" IN OrganizationName)';
Filter := 'TEXTSEARCH("democrat*" IN OrganizationName)';
Filter := 'TEXTSEARCH("weston democrat*" IN OrganizationName)';

But this doesn't:

Filter := 'TEXTSEARCH("democrat* weston" IN OrganizationName)';