Help Regarding Asp.Net Project

Create  PROCEDURE [dbo].[GetResult]  

@String varchar(200)  

AS  

BEGIN   

 

 --Fetch all applicants who belongs to College and StudentBatch Ids paased as argument

 DECLARE @tmpTableNm varchar(100)  

 

select @tmpTableNm=s 

    from dbo.SplitString(@String, ' ')

    where zeroBasedOccurance=5 

select department from @tmpTableNm

    

END  

Hi Arun,

If every time last value will be your table then you can split the string and take the last word and apply your select query on that. Something like this......
create function dbo.SplitString 
    (
        @str nvarchar(4000), 
        @separator char(1)
    )
    returns table
    AS
    return (
        with tokens(p, a, b) AS (
            select 
                1, 
                1, 
                charindex(@separator, @str)
            union all
            select
                p + 1, 
                b + 1, 
                charindex(@separator, @str, b + 1)
            from tokens
            where b > 0
        )
        select
            p-1 zeroBasedOccurance,
            substring(
                @str, 
                a, 
                case when b > 0 then b-a ELSE 4000 end) 
            AS s
        from tokens
      )
    GO
    select s 
    from dbo.SplitString('What are the department in allahabaduniversity', ' ')
    where zeroBasedOccurance=5