Text Search for age-group related words

  • Hi Everyone,

    I have an app that creates groups and designates members based on their age. Now I would like to be able to "suggest" a list of possible members by using the name/description of the group.

    For example, if the group name was "Essex Town FC U8", i'd like to get back a table of results as follows:

    Operator Value

    --------------------

    < 8

    I'd also be able to interrogate the description field too, for example: "The group contains members for the Essex Town FC under 12's and under 13's football team". From this, I'd like to retrieve the following resultset.

    Operator Value

    --------------------

    < 12

    < 13

    Once I've got this, I can then perform my own search on the users' ages to get back the "possible" selection.

    I'll be completely honest, this is a bit of a challenge for me, but having asked some challenging questions before and received some amazing feedback, I thought I'd at least ask the question here first! 😀

    Thanks all,

    Kev.

    For all your clubs - Our Clubs.
    Try out our new site today and see how it can help your club!

  • You will need to write your own artificial intelligent parser/translator of English sentences to convert them into dynamic t-sql.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • Thanks for the reply Eugene.

    I knew it wasn't a simple query...but I think for now, it might be out-of-scope for my current project. Perhaps at a later date, when I have time, I can revisit it and post up my solution here.

    Cheers,

    Kev.

    For all your clubs - Our Clubs.
    Try out our new site today and see how it can help your club!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply