There is a big difference in functions as well. For example, in Access, you can use Trim() to trim leading and trailing spaces, but in SQL Server you only have RTrim() and LTRim(). And the wizard doesn't automatically convert Trim() to RTrim(LTrim()) for you.