RIGHT (Level 2)
|SQL Server 6.x||SQL Server 2000|
|RIGHT was a reserved word.||RIGHT is a reserved keyword and should not be used for database object names (unless using identifiers). For more information about SQL Server 2000 reserved keywords, see Using Reserved Keywords.
Expect different results as compared to earlier versions of SQL Server because RIGHT is now a reserved keyword. For more information about using RIGHT with identifiers, see Using Identifiers.