SQL - substring and charindex

 

   1: SELECT

   2:     substring(IdeaText,1,

   3:         charindex('//', IdeaText)

   4:     ) as part1

   5: FROM tblIdeas

 

substring

charindex