Discussion board where members can get started with QlikView.
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?
Go to Solution.
I assume that you are using where condition with sql statement.
In SQL you dont use *, you use %.
SELECT * FROM Persons
WHERE City LIKE 's%'
Hope this will solve your problem.
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*');