| http://www.w3.org/ns/prov#value | - Use a case statement to check that before you do your substring.here is an example of why it fails:DECLARE @a varchar(50)SET @a = '1234567890'SELECT SUBSTRING(@a,5,LEN(@a)) -- This one is OK, normal substring.SELECT SUBSTRING(@a,5,LEN(@a)-5) -- This one is OK, your length is still 5 (10-5)SELECT SUBSTRING(@a,15,LEN(@a)-5) -- This one is OK, you can have a starting point past the end of the string.
|
