Remove Decimals using PATINDEX

DECLARE @somevalue VARCHAR(50) = '123459078.9005'; --set the initial value

DECLARE @nonZeroPosition INT -- variable to store the occurance of first non zero value position

SELECT @nonZeroPosition = PATINDEX('%[[.]%',@somevalue) --Ensures the occurance of a decimal

SELECT ValueBeforeDecimal = LEFT(@somevalue,@nonZeroPosition-1)

ValueBeforeDecimal
----------------------
123459078