Need help on creating a specific SQL statement
Does anybody know how to create an SQL statement to search for a word in a expression. Here is an example: The field Catagory contains this: "CAS;Arbitrage;4;LID;Holiday Cards;DM;Client;Perspectives;MRC;Key Customer;CFD;2;Announcements"
I want to create a query that displays all the users that should receive holiday cards. But my problem is that the feild catagory contains other text. How do I create a statement such as select * from table where Catagories = Holiday Card. Is there any thing I can use to scan the catagory field for the word Holiday Cards. Please let me know.
Thanks
I want to create a query that displays all the users that should receive holiday cards. But my problem is that the feild catagory contains other text. How do I create a statement such as select * from table where Catagories = Holiday Card. Is there any thing I can use to scan the catagory field for the word Holiday Cards. Please let me know.
Thanks