Select specific purchase price

[m_mcgee]

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!

[ajith007]

u can try this one

select productname from tablename
where purchaseprice like '%980'

[krishnaindia2007]

Try this

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

[krishnaindia2007]

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'