USE Mall
Go

SET NOCOUNT ON

---------- retrieving with wildcard _ ----------
-- ********** Begin ********** --

SELECT prod_id, prod_name, prod_price
FROM Products
WHERE prod_name LIKE '1_ inch%'

-- ********** End ********** --

GO