The only problem with using LEFT() is if the value to the left of the decimal is exactly 6 digits wide, then a "dangling decimal point" will be left, but I can code around that.

For some reason I had gotten target fixation on using CONVERT() alone. Thanks.