Search Word

[kumark]

Searching a Keyword in the string..Please Find the Enclosed Attachment


Regards
Kumar

 

[kumark]

I got the Solution ....


select * from t1, t2
where t1.STRING like '%' + t2.KEYS + '%'


update t1 set validate='found' from t1 inner join t2 on t1.STRING like '%' + t2.KEYS + '%'

 

[jdraw]

Interesting, but why do you need to UPDATE the record to show that the keyword was found??
Please describe a real world situation where this is used.

 

[kumark]

This Query Can be used to distinguish the items ... suppose if u are working on huge database which contains only engineering items in that there might be some medical items so if we get some keywords for it ... then easy to flag it off and remove it

 

[John Big Booty]

I would have thought it would be far simpler to have an additional field that contains a numeric index that indicates the nature of the part/product. Rather than search for a key word, that your user may have mis-keyed

 

[John Big Booty]

That filed could be populated by either an Option Group, or for more flexibility and ease of adding additional items, to the list, a combo box.