LTRIM and RTRIM Trimming Functions (Level 2)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
The LTRIM and RTRIM functions returned NULL in queries using zero-length strings:
|
Zero-length strings are supported. The queries shown return nonnull values; the first returns '' and the second returns 0.
Expect different results as compared to earlier versions of SQL Server. LTRIM and RTRIM provide different output from earlier versions of SQL Server. |