WorknHardr
asked on
SQL Substring Maximum Allowable Length?
I'm working on an existing stored procedure which uses Substring like so. I need to know what the limit is, 4000?
SELECT
SUBSTRING
( ( SELECT Names
FROM table1
FOR XML path(''), elements), 1, 4000)
SELECT
SUBSTRING
( ( SELECT Names
FROM table1
FOR XML path(''), elements), 1, 4000)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I guess no limit on that.
ASKER
thx