Can we use wildcard in Select?

datatable
excel
#1

Hi,

Can we use Wildcard in select?

I have uses wildcard character to extract data like [Data_Table_Name].Select([Field_Name] = 'Test’)*, but I am unable to get the data which I have expected.

#2

Yes, but you then need to use the Like operator, not =.

See here for eamples:
https://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression(v=VS.100).aspx
(scroll down to Wildcard Characters).

Regards.

#3

hi @andrzej.kniola, It’s working now. Thank you :slight_smile: