Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.70K
1 Posted Topic
It works in C# because you're likely using OLEDB to execute it, which means Jet/ACE is running in ANSI 92 SQL mode, where % is the wildcard operator. Within Access, the default is the legacy (and proprietary) ASNI 89 SQL mode, and that uses * as the wildcard.
The End.
deepakjoy