Timeline for Any reasons why SQL-92 changed *, ? into %, _?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 3, 2015 at 22:50 | comment | added | miroxlav | Too bad I can't mark two answers! Thank you anyway, very appreciated. | |
| Feb 3, 2015 at 16:07 | comment | added | miroxlav | Sure, I don't object. I'm actually not bound to MS Access and the question wasn't inspired by its SQL dialect. It was rather UX and feeling. (You can see come more context in comment below my question.) Let's wait a bit and then conclude the question. | |
| Feb 3, 2015 at 16:00 | comment | added | Blrfl | @miroxlav: Unfortunately, I can't find an online copy of SQL-89, but I have no reason to believe * and ? were in there. At the link in the answer, Microsoft calls them out as "wildcard characters that are specific to the Microsoft Access database engine to use with the Like operator." | |
| Feb 3, 2015 at 15:29 | comment | added | miroxlav | @DougM - thanks for the note. I can't find for sure whether the change was actually there. This answer was one of sources of my question. | |
| Feb 3, 2015 at 15:21 | comment | added | DougM | FWIW, your first paragraph would be better if you lead with "That was never part of any SQL standard." | |
| Feb 3, 2015 at 14:08 | history | answered | Blrfl | CC BY-SA 3.0 |