Thank You Very much.......:-)

Here Are The Answers From (MSDN Forum) :

you can use conditional operator and isnull to build your expression for example:

ISNULL(ColA)?(ISNULL(ColB)?(ISNULL(ColC) ?...

Thanks for your reply

"Koen Verbeeck" yes,may be or may not be a SCD type2 but its is a business requirement to handle if i get the previous records...