Board index » delphi » SQL Wildcard Search of a Blob Field

SQL Wildcard Search of a Blob Field

I am trying to create a select query of a Blob field without much
success.  The idea is to retreive a recordset based on a partial text.
So far I have tried

select * from DR where What like "..TD.."
select * from DR where What like '..TD..'
select * from DR where What = "..TD.."
select * from DR where What = '..TD..'

DR is the name of the table, What is the name of the field, and TD
occurs in three records in the table.

Please help if you can.  You can reply to appl...@abc.com

THanks

 

Re:SQL Wildcard Search of a Blob Field


On Thu, 6 Mar 1997 02:58:02 GMT, John Appleton <apple...@nji.com>
wrote:

Quote
>I am trying to create a select query of a Blob field without much
>success.  The idea is to retreive a recordset based on a partial text.
>So far I have tried

>select * from DR where What like "..TD.."
>select * from DR where What like '..TD..'
>select * from DR where What = "..TD.."
>select * from DR where What = '..TD..'

>DR is the name of the table, What is the name of the field, and TD
>occurs in three records in the table.

>Please help if you can.  You can reply to appl...@abc.com

>THanks

Use  the wild card. Try this select *from DR where what like "%TD%"

Other Threads