<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am using % as wild card but I am getting following error<br />
<br />
Syntax error in query expression 'Member.EmailID LIKE %a%'.<br />
<br />
How to use like operator in msaccess?<br />
<br />
Regards<br />
Karan Gupta<br />

</div>
</div>


Hi

I am using % as wild card but I am getting following error

Syntax error in query expression 'Member.EmailID LIKE %a%'.

How to use like operator in msaccess?

Regards
Karan Gupta


Like operator in MSAccess

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.