In MSSQL IF ELSE is not supported inside the SQL-Query.
For a similiar behaviour you should use CASE WHEN keyword.
WHEN [Productnumber] LIKE '112%' THEN 'SOFTWARE'
WHEN [Productnumber] LIKE '005%' THEN 'HARDWARE'
END as [ProductType]
The best Datatype for money in C# and VB.NET is Decimal.
What is the MSDN saying about Decimal.
The Decimal value type represents decimal numbers ranging from positive 79,228,162,514,264,337,593,543,950,335 to negative 79,228,162,514,264,337,593,543,950,335. The Decimal value type is appropriate for financial calculations requiring large numbers of significant integral and fractional digits and no round-off errors. The Decimal type does not eliminate the need for rounding. Rather, it minimizes errors due to rounding.