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

User 677b9c22ff

17-11-2006 21:07:16


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.



ChemAxon fa971619eb

17-11-2006 21:39:07

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.

ChemAxon d76e6e95eb

01-02-2007 15:36:16

That is asterisk :)))

User 677b9c22ff

02-02-2007 03:11:01

....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