Query Text
Hi Experts!
Say I needed to look through 500K flat files (each no larger than 3KB)
So, I created a table (Msg_tbl) with a feild called "msgtxt" as a text field.
The idea is to load each file into the table.
How do you query the field "msgtxt" if you want to find phrases such as "out of the blue"?
This is for SQL 2008.
TIA
Say I needed to look through 500K flat files (each no larger than 3KB)
So, I created a table (Msg_tbl) with a feild called "msgtxt" as a text field.
The idea is to load each file into the table.
How do you query the field "msgtxt" if you want to find phrases such as "out of the blue"?
This is for SQL 2008.
TIA
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thx Lowfatspread. full text search sounds like what I"m looking for.
I'll try to google up some example. Thx!
I'll try to google up some example. Thx!
ASKER
ASKER
I'll try once I've loaded all the files. Thx!