CODEWITHSUNDEEP
.netsqloledb
Jeff Stock
Jeff Stock

Reputation: 3856

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.

Upvotes: 1

Views: 563

Answers (1)

shahkalpesh
shahkalpesh

Reputation: 33476

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

Upvotes: 2

Related Questions