There was a fatal error in the SQL Statement.
Error number: -2147217913
Error Description: Error converting data type nvarchar to numeric.
Error Source: Microsoft OLE DB Provider for SQL Server
SQL State: 22018
Native Error: 8114
SQL: SELECT * FROM [Match_Goals] WHERE [Penalty] = 0 AND [MatchId]=36178 ORDER BY ( IIF(LEN([TimeScored]) > 0, IIF( PATINDEX('%:%',[TimeScored]) > 0 , CAST(Left([TimeScored],2) + RIGHT([TimeScored],2) AS INT) , CAST(CAST([TimeScored] AS DECIMAL(5,2)) AS INT) ),0))