Sorry the variable value got stripped out... here you go

If you're like me and want to clean up the decimal places during your select statement, you can use the following...

If you're like me and want to clean up the decimal places during your select statement, you can use the following function set:

Replace(Left( as varchar))), '.', '') as YourAlias

This...