OLEDB Like Query

[SaJ]

Hi All,

Can we apply 'Like Query' on OLEDB object? If yes, Please share the syntax

Thanks,
SaJ

 

[sahil_raina_91]

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'

 

[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?

 

[sahil_raina_91]

Here do we need add (% or *) as prefix & suffix in pattern?

SELECT * from [SheetName$] WHERE [ColumnName] LIKE '%abc%'