Please Help me for finding a word from field in SQL
-
Hi, Please anyone can help me for finding a word from a particular field from table in database of SQL. I have the problem below. DataTable Name: TempTable Field name: Dtail other field name: KeyWords in the Detail field i have data like: <--Begin--> (TenderProcess <> 'Sell' and (State in ('Gujarat') and (ProductName in ('Iso-9002 Consultancy','Audit') or ProductDetails like '% ISO %' or ProductDetails like '% ISO- %' or ProductDetails like '% ISO - %'))) <--End--> Above is the data in field of Detail Now my Question is: I want to get words if it found the word 'Product Detail like%%'in any record. Then for above ex. if I found the word it give output:ISO,ISO-,ISO - ------------------------------------------------------------ So from above ex. I how I get the output as above. Please help me.Reply me urgently. Jesal OK
-
Hi, Please anyone can help me for finding a word from a particular field from table in database of SQL. I have the problem below. DataTable Name: TempTable Field name: Dtail other field name: KeyWords in the Detail field i have data like: <--Begin--> (TenderProcess <> 'Sell' and (State in ('Gujarat') and (ProductName in ('Iso-9002 Consultancy','Audit') or ProductDetails like '% ISO %' or ProductDetails like '% ISO- %' or ProductDetails like '% ISO - %'))) <--End--> Above is the data in field of Detail Now my Question is: I want to get words if it found the word 'Product Detail like%%'in any record. Then for above ex. if I found the word it give output:ISO,ISO-,ISO - ------------------------------------------------------------ So from above ex. I how I get the output as above. Please help me.Reply me urgently. Jesal OK
:zzz::zzz::zzz::zzz: