>I created the function successfully in 2 other databases but still getting the same error in the database I need. Obviously there is something different about it.
>
>What should I check?

What's compatibility level for the database?

sp_dbcmptlevel