search a binary field on a SQL Server

[PlsHlpKat]

I am trying to search a binary field on a SQL Server database. I thought I could enable full-text searching for the database, create a full-text catalog, enable full-text search for the specific table (create index, add columns to it, populate it). I think at this point I could use special functions like ‘Contains’, ‘Freetext’, ‘Proximity-type functions’ – like ‘Near' and others in a SQL statement. Not sure this is the only way…" But when I tried enable full text on the table with the binary field I got the following error:
The selected table has no
unique single column index on a column that does not allow NULLS.
Database: dummy
Table: [dbo].[PART_BINARY]

Is there a better way to do this?
Thanks
Kat

 

[mrdenny]

You are on the right path. You need to create an index on your primary key (or another single column that provides uniqueness).

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com