is there any way to to check whether the value present in row for multiple columns
<p>I have a String variable <code>abc</code> . Now I would like to check whether the value of <code>abc</code> is present in a searched row form sql (table X ) for multiple COLUMNS.</p>

<p>So if (<code>abc</code>) is present in <code>COLUMN01 ,COLUMN02, ....COLUMN50</code>. Let's say flag <code>PRESENT</code> is set.</p>

<p>I have this kind of requirement. It can be accomplished by hard coding and checking all the 50 columns one by one. </p>

<p>Is there any other way?</p>
