Sql To Caml Query Converter Money
Caml Query Editor
It will be hard because the only convert option you can use itselect convert ( varchar ( 20 ), cast ( ' as money ), 1 )but it will return you decimal points 32,333.35 and you have to remove decimal point ond fraction after this, and teh best to do it is to create function which will do it.something likeselect SUBSTRING(VALUE,0,CHARINDEX('.' ,VALUE))or you can doselect SUBSTRING ( VALUE, 0, CHARINDEX ( '.' , VALUE )) from( SELECT convert ( varchar ( 20 ), cast ( ' as money ), 1 ) VALUE ) TEMPthanksJPazgier.