Return all results where category equals this or this or this, MS Access db on a classic asp page using strSQL Options

[Pluribus]

Hello

Can someone point me in the right direction to working out the correct string for this query?

I have a column in my database named "Category". I want to return all results from this column where the category equals 123, abc and xyz.

I can do it with one category, I have never managed to get 3 categories to work.

This is the connection string I use currently:

CODE

strSQL = "SELECT * FROM Table1 WHERE category=abc ORDER BY ID DESC"

Is this possible?

Regards

Ian