Access ANSI 89 vs. 92: Wildcards & Compatibility

In this Microsoft Access tutorial, I will show you how to manage ANSI 89 and ANSI 92 SQL syntax settings to prevent issues with the "Like" and "ALike" functions in your queries. We'll explore wildcard differences, compatibility with SQL Server, and provide solutions to fix this common problem.

Amber from Torrance, California (a Silver Member) asks: I'm using Microsoft Access, and every time I type Like in my query, it automatically changes to ALike. This is really frustrating, and I can't figure out how to stop it. Why is this happening, and how can I make it stop?

Recommended Courses

• Access SQL Seminars

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, ANSI 89, ANSI 92, wildcard differences, MS Access SQL syntax, wildcard compatibility, ALike issue, ANSI settings, query design, Access options, SQL compatible syntax, wildcard query problem, Access ANSI format, Access SQL query fix, ANSI 92 setting modification