Query to group like words

[markjeff]

Hello
I have a text box in my database that i would like to be about to search and group the text field if is had similar. for Example if I had a record like" called in puking" and "Up all night puking", I'd like the query to recognize "puking" (without me specifically telling it to look for "puking") and group them.

is this possible?

 

[RV]

You could use the Like operator.

If you're after some sort of intelligent data comparison, that's not going to be straight forward, assuming it's possible at all

Run a search here on soundex.

RV