|Subject||Re: How to store value in different currency ?|
> select * from Table1yes but with around 100 currencies it's will be an heavy query.
> where ((currency = 1) and (foreignvalue = 123.45)) or ((currency = 2)
> and (foreignvalue = 23.45)) ...
i was thinging to move this inside an UDF
where UFDConvert(Price, FromCurr, ToCurr) = xxx
not sure if it's the best