中国教程网论坛 » MS Access & SQL » How can I write this SQL?

poop 发表于 2008-2-1 16:21

How can I write this SQL?

List all columns of the Product table that contain the word INK JET in the product name?

我是这么写的，但关于INK JET这里好象不太对，请高手指导下下呢#kt..jcwcn.com@

SELECT *
FROM PRODUCT
WHERE PRODNAME >= '*INK JET'

查看完整版本: How can I write this SQL?