Oracle to SQL Server - Select and Insert Issues

Currently migrating Oracle to SQL Server and am re-writing several ColdFusion and .NET apps. I'm running into problems converting SELECT and INSERT commands...things like SUBSTR, SYSDATE, and (+) which work with Oracle tables do not work against SQL Server 2005 tables. I need a good online reference for converting commands that work against Oracle to the proper syntax for SQL Server. Any ideas? Thanks!

Check out this MS page:

http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx

Near the bottom of the page there is a White Paper "Guide to Migrating from Oracle to SQL Server 2005". Follow the link and download the word doc.

The white paper has a table showing Oracle funtions and the analagous SQL Server function.

Enjoy!

BTW
if + is used for concatenation SQL Server uses & instead.
Instead of sysDate try Now or Date.
Not sure about Substr since I'm not sure what it does.