LEN(expression), -length), but of course this is not valid syntax for SQL Server. The RIGHT function can be “rewritten” as a LEFT function by usingREVERSE, which returns the expression in reverse order.