Search using "*" ...

[Quevas]

How to search words using "*" in a database?

i.e.:
H* will display House, Home, Help...

I think it's possible through an SQL query, but I don't know the right sintax.

Any ideas?

Thanks.

[tomarius]

select * from whatever where xxx like "h%";

[Quevas]

ass :eek:

I guess I've to buy an SQL manual... :p

Thanks...🙂