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:
(scroll down to Wildcard Characters).
Regards.
hi @andrzej.kniola, It’s working now. Thank you