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.
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.
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.