Wildcars icm LIKE

[#1]

WHERE (OMSCHRIJVING LIKE 'Inventarisatie*');

When I use WHERE (OMSCHRIJVING LIKE 'Inventarisatie 31-03-2011');  it's going well, but testing it with a * behind the date it's going wrong. Any idea?

[#2]

Not sure why it is not working for you, it works for me. Check out the attached application.

You may make this to work with WildMatch() function as well.

    Where  WildMatch(OMSCHRIJVING, 'Inventarisatie*');

- Sridhar

[kaushiknsolanki · Accepted solution]

Hi,

    I assume that you are using where condition with sql statement.

    In SQL you dont use *, you use %.

    For Example.

    SELECT * FROM Persons

    WHERE City LIKE 's%'

    Hope this will solve your problem.

Regards,

Kaushik Solanki