Search Through SQL

Search Through SQL

Post by AAM Fai » Thu, 13 May 2004 12:11:27


ie Address Field having PO Box 1121. Then i just need to find Box only how
do get it done using it ?

SELECT ALL
FROM CUSTTBL
WHERE Address LIKE 'Box'

I tried so many time. It won't work.
Pls some one help me. I'm using Delphi 7 SQL
 
 
 

Search Through SQL

Post by Mike Shkol » Thu, 13 May 2004 13:48:23

SELECT *
FROM CUSTTBL
WHERE Address LIKE '%Box%'