I want to compute a new Field A which would be the minimum of 2 existing fields B and C, I was expecting to do
Select min([B],[C]) as [A] from Table
But this doesn't work since the word 'min' is an agregate function which intends to returns the min of a specific field...
So I did this workaround but it is not very elegant...
select (case when [A]<[B] then [A] else [B] end) from Table
Is there a better way to do so?