Sunday, June 1, 2008

SQL - substring and charindex

 

   1: SELECT
   2:     substring(IdeaText,1,
   3:         charindex('//', IdeaText)
   4:     ) as part1
   5: FROM tblIdeas

 

substring

charindex

No comments:

Post a Comment