Asterix search in text fields *,?,/\+~ ???

Hi,


how can I perform an asterix search or fragment search in text fields or free defined fields? Can I use regular expressions? The LIKE, In List, between etc seem not very helpful for doing such a search.


Thanks


Tobias

Use the database wildcard character % with the LIKE operator. e.g.


hello% -- matches anything begining with hello


%world -- matches anthing ending with world


hello%world -- matches anything starting with hello and ending with world, with anything else in betweeen.








All queries are converted to SQL queries. Regular expression searches are not supported in SQL (at least not in a manner that can be applied to all databases), so this is not possible.

That is asterisk :)))

....thats true :-)





After reading it again, it looks like I made a subtle joke,


but I did infact NOT.





Give me ※ (an asterisk).


Mmmhh the google fight is still on.





Kind regards


Tobias