Search code examples
.netsqloledb

What are valid SQL functions for OLEDB provider for querying a text file?

Does anyone know of any documentation out there that lays out what SQL functions are supported for the .NET Microsoft.Jet.OLEDB.4.0 provider when querying a text file?

For instance, the TRIM() function. However, there doesn't appear to be a CASE function like in SQL Server.

Solution

  • I don't know of any such reference. But see if using IIF helps.