How to check 'contains' in sql? Suppose 'allotedTo' column contains multiple values like 'ABC/xyz/RAM'
How do I load all rows, with 'allotedto' column containing any one of given input values?
(eg: all rows alloted to RAM or KLM) ?      

Here, we don’t want the solution to repeat column name multiple time like below:

select * from table where [allotedTO] like '%RAM%'  OR [allotedTO] like '%KLM%'


We want to implement solution similar to below queries, but it is not working   :

select * from table where [allotedTO] like '%RAM|KLM%' 


SELECT PATINDEX('%[RAM|KLM]%', [allotedTO])
For the specific example:

WHERE [allotetTO] LIKE '%RA[MJ]%'


For more complex ones, you could use a join to a values table with the wanted patterns: