Search SQL image datatype

[Matt Mercer]

Hi,

I have an ASP .net application running on an SQL database. I upload my
files directly into a database table (small attachments) of "image"
datatype. If I wanted to search for a word contained in one of the
uploaded attachments, is there a way to take this input from the user,
convert it to binary, and search for it? Or even a better way to do
it? Thanks.

[Kevin Spencer]

Looking for a (text) word in a binary image file? That would be a trick! Am
I misunderstanding you somehow? What kind of "attachments" are we talking
about storing here?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living

"Matt Mercer" <ma******@bellsouth.net> wrote in message
news:37*************************@posting.google.co m...

Hi,

I have an ASP .net application running on an SQL database. I upload my
files directly into a database table (small attachments) of "image"
datatype. If I wanted to search for a word contained in one of the
uploaded attachments, is there a way to take this input from the user,
convert it to binary, and search for it? Or even a better way to do
it? Thanks.

[Steve C. Orr [MVP, MCSD]]

Your binary search idea is flawed in too many ways to list here.
A better approach is keywords.
When uploading the file into SQL, require the user enter some keywords, and
save those keywords in one or more fields related to the file.
Then just search the keywords fields.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Matt Mercer" <ma******@bellsouth.net> wrote in message
news:37*************************@posting.google.co m...

Hi,

I have an ASP .net application running on an SQL database. I upload my
files directly into a database table (small attachments) of "image"
datatype. If I wanted to search for a word contained in one of the
uploaded attachments, is there a way to take this input from the user,
convert it to binary, and search for it? Or even a better way to do
it? Thanks.