SQL from Access

Hi All.

I used MSAccess97 during the design of my website and now want to connect to an SQL server.

The problem is that none of my query strings seem to work anymore. I thought SQL would work the same in SQL server as it does in Access???
I know i've connected to SQL server ok because "SELECT * FROM tblTable" works. But things like "[firstName] & [lastName] as PersonName" don't work anymore.

Is there somewhere I can convert these strings or does anybody know where I can read a bit more about the differences?

Thanks,
Adam.

Try using the + instead of the & symbol and it should work. There are a few differences like that between the two.