SQL Wild Card?

[mrmean]

I am tryin to select images from my access DB by file name extensions.

My select statement looks like this:

SELECT * FROM Images WHERE Image IS '*.png'

This is throwing an error. How should I execute this statement so it works correctly? Basically I want to return all records where the field of Image contains a *.png image.

thanks

[Gibble]

SELECT * FROM Images WHERE Image LIKE '%.png'

[mrmean]

oh wow, thanks a ton! it works. Thanks for quick response.

[Gibble]

No problem