I have a column name Capacity_Band3 with the value as follows
'0.8617 x SOQ ^ -0.2155' which is a string.
I am trying to extract the first and last bit in this example 0.8617 by using
cast(substring(Capacity_Band3,1,7) as numeric))
USE LEFT and Right Function to extract number
THEN Apply Cast Operation
SELECT CAST(LEFT(ColumnName,6) AS DECIMAL(18,2)),CAST(RIGHT(ColumnName,6) AS DECIMAL(18,2))