Hi,

am trying to give some more brief..

my previous requirement is

I having a table with 5 columns

Record_idCol1Col2Col3Col4Col5

------------------------------------------------------

101AABAA

102BBNULLNULLB

103CCCNULLC

104DCDDD

105AAAAAA

106BCAAAD

if record 101 contains all 5 columns same (i.e:A) then only "A" should be inserted into another

table

in record 101, col3 contains "B" then it should be skipped.

in record 102 - 3 columns contains B and 2 columns contain NULL, then it should be inserted.

Record 101 - SKIP

Record 102 - Insert B in to another table.

Record 103 - Insert C in to another table.

Record 104 - SKIP

* if in any record that contains "AA" in any column, it should return "AA" (records 105, 106)

Now i've inserted a new column called summary (summary column is a concatenation of all columns

*** i want the same above logic should be implemented in summary column.