Select specific purchase price

How to write a query to if you need to see only the products for a particular price. For example, I need to only see products that have 980 as the last three digits of the purchase price. The products column is call vehicles, the price column is called list_price, the table is table_inventory.

Please Help!

u can try this one

select productname from tablename
where purchaseprice like '%980'

Try this

SELECT vehicles,list_price
From table_inventory
WHERE list_price like '%980'

You may get the result in this way also

SELECT vehicles,list_price
FROM table_inventory
WHERE substr(list_price,-3,length(list_price)) = '980'