Hey all, i would use the search function to get an answer to this but i'm getting a forum db error when i try to :eek:
So here's my question...
I have a table which has several fields in it, and will grow to have hundreds, if not thousands of records in it.
What i'd like to know is how/what is the best way to search through the 'ProductDescription' field to find keywords or maybe even similar keywords to what the user searched for?
I know I could pull a copy of that field off the server for every record, sift through it all and find matching words, but I know there has got to be a better way of doing it!
Thanks a lot if you can help me!
