Why o why an image field...???

[GilbertLiddell]

Hi,

Just started working on an app where text has been saved in an image field in an SQL Server 2000 database. I need to search though the text for a specific string then carry out a function.

I'm able to get the data out into a txt doc and then search for the string but this takes quite some time (i've got about 25,000 records to process). I also tried the memorystream/streamreader -

Dim d1 As New StreamReader(imageBytedata)
Dim cSingleChar1 As String
Dim intSingleChar1 As Integer
d1.BaseStream.Seek(0, SeekOrigin.Begin)

While d1.Peek() <> -1

intSingleChar1 = d1.Read()
cSingleChar1 = Chr(intSingleChar1)
txtOUTPUT.Text = txtOUTPUT.Text & cSingleChar1
​

End While

This also takes ages, any suggestions

PS. I'm new to vb.net

 

[GilbertLiddell]

Any takers??

 

[cjard]

http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/ ?