so currently I’m making a simple database a company to sort their documents into clauses specified by BRCGS standards. The documents are listed like the following examples “QUA 012.2, PRO 034.1, Misc 044.1, etc.” I have been trying for the life of me to get a query working where I can just get the Misc documents, but it is not working.

I’m a very beginner with SQL and database and I received a task to completely rebuild a project monitoring application we have here. The problem is, I only have access to the database (MS Access) cause the app itself was coded in Delphi and I don’t have the sources. Anyway, I check the Access database and choose to export it to SQL for a better performance and security but the way the DB was made… I’m not really sure it was the best way.

I’m a very beginner with SQL and database and I received a task to completely rebuild a project monitoring application we have here. The problem is, I only have access to the database (MS Access) cause the app itself was coded in Delphi and I don’t have the sources. Anyway, I check the Access database and choose to export it to SQL for a better performance and security but the way the DB was made… I’m not really sure it was the best way.