[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Comment on test case for LEFT()
Section 6.19.10 "Left" has this test case: Expression: =LEN(LEFT("xxx";-0.1)) Result: Error Level: 1 Comment: It makes no sense to request a negative number of characters. Length is converted using INT, towards negative infinity, so Length becomes -1 That is a bit subtle, and doesn't just test LEFT(). In particular, it will fail if the implicit conversion goes to 0 instead of -1. Suggest that the expression should be: =LEFT("xxx";-1) which would just test LEFT. Brad
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]