ISNUMERIC() checks whether the input is valid numeric data, that also includes money data type, thats why it used to return 1 for isnumeric('0,.0') cause its a valid money type....

Hiiiiiii

u can use the below one...

select (case when CurrencyOld is NULL then CurrencyNew else CurrencyOld end) Currency,

(case when BalanceOld is NULL then BalanceNew else BalanceOld end) Balance from URTable

You can use order by clause with top in select like

select top(2) * from Table order by Id

Thanks Carrisa

Really a good logic(Short and sweet).

Thanks a lot simsr it worked perfectly for me...

Thanks a lot Allen that's the query i exactly wanted.

Thanks Steve for ur quick response, but whether there is any way to do that work with Group by clause instead of Union?