Link to home
Create AccountLog in
Avatar of jbrahy
jbrahy

asked on

how do I generate keywords from a nvarchar field in a mssql 2005 database?

I need to generate keywords from a large nvarchar(max) field in a database. Does anyone know of any algorithms for doing this? or is there a way to do it with full text indexing? the database is mssql 2005.
Avatar of Aneesh
Aneesh
Flag of Canada image

Hello jbrahy,

Keywords ? can you give an example ?



Aneesh R
Avatar of jbrahy
jbrahy

ASKER

ok, let's take the text of your comment:

Hello jbrahy,

Keywords ? can you give an example ?

Aneesh R

the keywords in that would be hello, jbrahy, keywords, example and aneesh. I don' think any of the other words would be considered keywords or helpful in search results.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of jbrahy

ASKER

I've never used full text indexing so I wasn't aware of that. the end result of what I want is to link product descriptions with article keywords so I need to have two sets of keywords and return the best matching results.

Could you point me to an example of something like that?
Avatar of jbrahy

ASKER

so another question with no answer....