Thanks Friend
OriginalGriff
,
I solve the issue the below script is giving me my output
SELECT COALESCE(CASE ROUND(Col1 / 10000,0) WHEN 0 THEN Null ELSE ROUND(Col1 / 10000,0) END * 10000,10000)
Thanks for your code which give me direction for the output.
Thanks and Regards