Reading buffer strings

• Marcus Kvarnström

  SSC Rookie

  Points: 34

  More actions

  May 30, 2005 at 6:49 am

  #164823

  Hi,

  does anyone know if there is a T-SQL function which works like VB/C# inStr/indexOf?

  Thanks!

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  May 30, 2005 at 6:52 am

  #561687

  CHARINDEX and SUBSTRING

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Marcus Kvarnström

  SSC Rookie

  Points: 34

  More actions

  May 30, 2005 at 6:58 am

  #561688

  Many thaks Frank!

  the CHARINDEX did the job!