hi all,
how to split the text in sql server using stored procedure like
@serchtext='city,sate'
how to split city ,sate separate my out put like
@city=city
@state=state
my query like this
ALTER PROCEDURE [dbo].[SP_TESTSEARCH](@Mode int,@INDUSTRY varchar(100),@JOB_TYPE varchar(100),@SERCHTEXT VARCHAR(100))
AS
BEGIN
Declare @city varchar(100);
Declare @sta varchar(100);
SET @city=SUBSTRING(@SERCHTEXT,0,CHARINDEX(@SERCHTEXT,',',0)-1)
Set @sta=SUBSTRING(@SERCHTEXT,(CHARINDEX(@SERCHTEXT,',',0)+1),(lEN(@SERCHTEXT)-(CHARINDEX(@SERCHTEXT,',',0)-1)))
but i got the error like 'Invalid length parameter passed to the LEFT or SUBSTRING function.'
how to write a query for split and set the values for declare variables
thanking you