Searching for data with *

[fromb]

I use Delphi 5 and Absolute database and am looking for a way to search for data in the database by using * e.g. if I’m looking for software to use *ware to search. I suppose it would be possible through sql but I have no knowledge of sql. Can someone please help?

 

[xwb]

In SQL the wildcard character is %. If it is used, the LIKE operator has to be used instead of =. Supposing you wish to look in a table called wtbl for words with ware in it.

SELECT * FROM wtbl WHERE word LIKE '%ware%'