comparing two columns with several text in each column

[dmasvar]

is there a way of comparing two colunms of text say and drawing out the similiarities, wehther exact match or partial match...

would appreciate any assistance..
eg

one column may have

cat, camp

and 2nd column could have

cake, cow

the output column 3rd column

if i ask to match "ca" it should say there is a match and bring out cat, cake camp


is this possible how do i do it.. sql?expresison builder?

 

[pritcham]

Hi

I notice that you've asked this question a number of times now, all in different threads and people (including me) have tried to help but you really need to give more information and to be honest, if people have taken the time to reply but they're asking for more info so they can try and help it's probably an idea to reply to them for courtesy sake if nothing else.

As for this version of your question - take a look at the "LIKE" expression as it may get you towards where you need to be.

Martin