All,

Given the user input being the numeric value between 249.99 and 999.94 with 2 decimal places and always ending in .99 I have to return a number that is evenly divisible by 3 with up to 2 decimals.

Example:

User enters 599.99 and I have to display that he needs to use 599.97.

Any idea how to code it in VB.NET or T-SQL?

thank you,
Daniel