SQL Query

• O.R.Anandaraman

  Newbie

  Points: 1

  More actions

  March 1, 2005 at 1:31 am

  #76251

  Hi,

       I Want to search a given string into another string, if it is available display its position. using sql query

  ex :

  materialcod

  sub001-001

  after the hyphen only i want

• Helen-84411

  Hall of Fame

  Points: 3320

  More actions

  March 1, 2005 at 2:46 am

  #544551

  Hai,

  Use this

  select substring('sub001-001',charindex('-','sub001-001')+1,len('sub001-001'))

  If it is a column then use this

  select substring(materialcod,charindex('-',materialcod)+1,len(materialcod))

   

   

  
  Helen
  --------------------------------
  Are you a born again. He is Jehova Jirah unto me