Database

'%' & strsearch & '%'

dadsubmit = New SqlDataAdapter(
   String.Concat("SELECT AuthorId, UrlUserName, Urlid, UrlAddress, ChooseMedia, Title, ", _
                 "Description, ChooseThumbnail, ChooseTopic, Datetime, ", _
                 "(SELECT COUNT(CommentId) AS Expr1 FROM CommentTable WHERE ", _
                 "(CommentUrlid = Submitnewtable.Urlid)) AS cnt, ", _
                 "DATEDIFF(day, Datetime, GETDATE()) AS diff ", _
                 "FROM Submitnewtable WHERE Title like '%", strsearch.Trim(), "%';") _
    , consumit)

declare @str as varchar(100)
declare @startposition int
declare @endposition int
declare @stopingcondition int
declare @delimeter char(1)
set @startposition = 0
set @stopingcondition = 15
set @delimeter =''
set @str = 'I would like to get first 15 word from a long sentence but not sure how to do this. I guess I should be looking for 15th space in the word but not sure how to do this could some please help?' -- original data

--Program starts
;with num_cte as
(     
      select 1 as rn
      union all
      select rn +1 as rn 
      from num_cte 
      where rn <= len(@str)
)
, get_all_delimited_char_pos_cte as
( 
      select  row_number()over(order by rn) cnt ,rn,chars       
      from num_cte
      cross apply( select substring(@str,rn,1)  AS chars) splittedchars 
      where chars = @delimeter      
)
select @endposition = rn from get_all_delimited_char_pos_cte where cnt = @stopingcondition
select SUBSTRING(@str,@startposition,@endposition) as First15thWords

I would like to get first 15 word from a long sentence but not sure

declare @str as varchar(100)
set @str = 'I would like to get first 15 word from a long sentence but not sure how to do this. I guess I should be looking for 15th space in the word but not sure how to do this could some please help?' -- original data

select SUBSTRING(@str,0,68)