Searching for existence of specific value within column

[aalnaif]

Consider the following pseudo-code for an IF statement:

if(maintable.call_type contains at least one instance of 'E')
then ...

Call_time is a column within maintable.
For example, if maintable.call_time contained the values {A,A,B,D,A,B,E,B,C,E,D} then the statements inside the if-statement should be executed (since the colum contains at least one instance of 'D')

Would something like this work:
if('E' IN maintable.call_type)
then ...

 

[aalnaif]

Sorry, there are a couple typos in my first post, where I typed call_time instead of call_type. Replace all of the call_times in my post with call_types.