Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Wildcars icm LIKE

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?

1 Solution

Accepted Solutions

Wildcars icm LIKE

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

2 Replies
Not applicable

Re: Wildcars icm LIKE

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

Wildcars icm LIKE

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

Community Browser