Hi Eugene,

I agree with what ur saying,

here am giving some more details,

--

;WITH Mysample (Record_id, Col1, Col2, Col3, Col4, Col5)

AS

(SELECT 101, 'A', 'A', 'B', 'A', 'A' UNION ALL

SELECT 102, 'B', 'B', NULL, NULL, 'B' UNION ALL

SELECT 103, 'C', 'C', 'C', NULL, 'C' UNION ALL

SELECT 104, 'D', 'C', 'D', 'D','D' UNION ALL

SELECT 105,'AA','A','A','A','A'UNION ALL

SELECT 106,'B','C','A','AA','D')

SELECT Record_id, Newcol

FROM Mysample

CROSS APPLY (

SELECT Newcol = CASE WHEN MAX(Newcol) = MIN(Newcol) THEN MAX(Newcol) ELSE NULL END

FROM (VALUES (Col1), (Col2), (Col3), (Col4), (Col5)) X (Newcol)

) d

WHERE Newcol IS NOT NULL

above query i got from SSC team - Really thanks.

now my requirement is i've to search in final column only, final column is the concatenation of 10 columns

(col1 + col1_expiry_date + Col1 + col2_expiry_date......+col5_expiry_date)

finally i want the search should be happen from the final_column

Please help...