DECLARE @Input DECIMAL(10,4);SET @Input = 12345.6789SELECT @Input - FLOOR(@Input) AS [DecimalPart]GO
Login to post response