Simple SQL question

[meeble3]

Hello.

I am making an SQL query for Access and I wanted to select all records that have the three letters 'LON' in that order in a particular field.

I thought the query was


SELECT * from table where fieldname LIKE '%LON%'


but this doesn't work.

What is the correct syntax?

Cheers

James

 

[ByteMyzer]

For Access SQL Syntax it should be:
[tt]
SELECT * from table where fieldname LIKE '*LON*';
[/tt]