Posted by SafeEarthSafeChild on 08/14/07 06:09

In TransactSQL % is the wildcard
SELECT *
FROM Table
WHERE Table.Field LIKE '%Example%'

But how do I find "% solids" or just "%"?

--
Jennifer Gibbons
Hold your dreams close to your heart, give them wings, and let them fly.
http://safeearthsafechild.fourpointmoms.com

[Back to original message]