执行分割功能时出错 [英] Error while executing Split Function

问题描述

Create function dbo.fnSplit_Vehicle
(@sInputList varchar(100), @sDelimiter varchar(1))
returns varchar(100)
--select dbo.fnSplit_Vehicle ('1234 abcd', '-')
AS
BEGIN

Declare @Domain varchar(100)

set @Domain = RTRIM(LTRIM(SUBSTRING(@sInputList,1,CHARINDEX(@sDelimiter,@sInputList,0)-1)))

return @Domain

End

我遇到错误

i m getting the error

Msg 537, Level 16, State 2, Line 1
Invalid length parameter passed to the LEFT or SUBSTRING function.

请帮助

please help

推荐答案

希望

Hope this[^]might help you to solve your problem.

这篇关于执行分割功能时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！