Hi All,
Can we apply 'Like Query' on OLEDB object? If yes, Please share the syntax
Thanks,
SaJ
Yes, you can apply 'LIKE Operator' on a Query in OLEDB.
The syntax is same as SQL.
Example : SELECT * from [SheetName$] WHERE [ColumnName] LIKE 'pattern'
Here do we need add (% or *) as prefix & suffix in pattern?