HELP: SQL query using LIKE and % wildcard

[Guest]

Hi i have a query that looks like this:

SELECT Dagsrapport.Anlaggning, Dagsrapport.Notering
FROM Dagsrapport
WHERE Dagsrapport.Notering Like '%porslin%';

This query is supposed to return "anlaggning" and "notering" from my table
"dagsrapport" where the field "notering" should contain the word 'porslin'.
'Porslin' can be one word or part of a word so have to use the % wildcard.
The problem is that i dont get any result, but i know that there are fields
that contains this information.

Any ideas on what i might be doing wrong?

regards,

//Eric

 

[Ali]

I think the % wildcard is for SQL Server. Try using * instead

 

[Guest]

Yes now its working
Thank you!

"Ali" skrev:

I think the % wildcard is for SQL Server. Try using * instead