OTBI: how do we check if one column value is present inside another column

Summary

OTBI: how do we check if one column value is present inside another column

Content

Hi,

Need a logic to compare if one column value is present inside another column

AND

also a logic to check if a column value contains ONLY letters of an alphabet.

Any advise pls.

Regards

Rashmi