SQL Server Error Message: Invalid length parameter passed to the substring function
Server: Msg 536, Level 16, State 3, Line 1 Invalid length parameter passed to the substring function.
This error is caused by passing a negative value to the length parameter of the SUBSTRING, LEFT and RIGHT string functions. This usually occurs in conjunction with the CHARINDEX function wherein the character being searched for in a string is not found and 1 is subtracted from the result of the CHARINDEX function.
LEFT(@String, CHARINDEX(' ', @String) - 1)
If the character is not found in a string, a space in this example, the CHARINDEX function will return a value of 0. Subtracting 1 to this will become -1 and using this as the length parameter in the SUBSTRING or LEFT functions will result to this error.
Need Additional Assistance?
Xynomix and we'll assess your issue and help to action a fix.
On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.
Enterprise Architect – North Yorkshire County Council
“Xynomix worked with us on our recent Oracle License Review and provided us with valuable independent and confidential advice to help us through what can be a confusing and complex process. They provided useful expert knowledge on Oracle Licensing policy and also suggested how any gaps could be most effectively licensed. I would certainly recommend working with Xynomix on any future Oracle License Review.”
Lead Database Administrator – Manufacturing Industry
“We have been running Microsoft SQL Server for around two years now and the systems have been supported by Xynomix. Their SQL DBAs are competent and very customer-facing.”
IT Manager – Public Sector
“We first approached Xynomix for advice on Oracle licensing. They saved us money there, and a year on we have a full database management contract with them.”