By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

ANSI SQL Compatibility.

NeoPa
Expert Mod 15k+
P: 31,656
I was looking something up yesterday at home on my Access 2003 format database and I noticed that using a 'Like' phrase in my SQL was translated to 'Alike'??!?
Confused I looked it up in Help and found that it was to do with compatibility modes. The options were ANSI-88 & ANSI-92 (or some such numbers). The newer version was compatible with SQL server - Wildcard = % rather than * and _ instead of ?. I looked for a new option which would allow me to set my compatibility mode but found none. Can anyone throw any light on this matter?
I've assumed that new (2003) databases use the new format and previous ones the older. I'm just surprised that this would be foisted upon an unsuspecting public without warning.
Dec 1 '06 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
Check the Tables/Queries tab of the Tools/Options.
Down right you have the ANSI92 compatibility checkbox.

Nic;o)
Dec 1 '06 #2

NeoPa
Expert Mod 15k+
P: 31,656
Thanks for that Nico.
I looked but didn't see (before I mean - I see it now).
Dec 2 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.