Need query to select using WHERE from a list 1

[hapax]

I need to select using a WHERE clause that contains a list of specific items. What's the syntax?

I want to do this:

SELECT * from ASSET
WHERE AssetId
(is in the following list of IDs: 214, 727, 317 or 283)

 

[RiverGuy]

SELECT * from ASSET
WHERE AssetId IN
(214, 727, 317, 283)

 

[hapax]

Excellent, thanks.

I researched using IN but didn't see an example of this type of case.