ODBC Read Failed

[#1]

Hello All,

Im attempting to run the following statement (specifically the part in italic),

But QlikView bombs out and throws an ODBC Error,

This appears to be valid a statement, as when i run it SQL Server I get the expected result.

Please advise if there is anything that needs to be changed to run successfully in QV.

SQL SELECT

Value,

TicketId,

"Key",

substring(Value, charindex('//', Value) + 2, charindex('/', Value, charindex('//', Value) + 2) - charindex('//', Value) - 2) as Trim

FROM CORE.dbo.Table;

Thanks

BR.

[#2 · Accepted solution]

Managed to resolve this,

Using the TextBetween() function. Gets the same results.

Thanks to anyone who looked.

Jeremy