It is not exclusive to Microsoft Access. That said, some commands might differ slightly, and the steps you need to take to enter and run SQL might be different.

SQL server will allow zero-length strings without issue, as long as your datatype supports it. Just assign the string value of ('') and you're done, no headaches.