SQL query "10%" in a field

From: <shiuhlin_at_jshape.com>
Date: Wed, 13 Dec 2000 00:08:12 GMT
Message-ID: <916el8$ci5$1@nnrp1.deja.com>

Hi,

I have a problem needs help. My problem is : I have a table called "DOCS" which contains a field called "NEWS", and I like to perform a query to find all records which contains "10%" key words in the NEWS field. The "%" in "10%" (10 - percent) isn't the wildcard character used in SQL. Now, can anyone show me how to find the "10%" in NEWS?

SELECT NEWS FROM DOCS WHERE NEWS LIKE ????? Shiuh-Lin Lee

Sent via Deja.com
http://www.deja.com/ Received on Tue Dec 12 2000 - 18:08:12 CST