Get row count based on CHARINDEX RSS

• • Reply
  

  Chithra_Iyer

  Member

  89 Points

  414 Posts

  Get row count based on CHARINDEX

  Jan 01, 2013 01:55 PM|LINK

  I have a table that has a PlanId field which has the values as below

  BP-GEN1
  BP-MOT1
  BP-HOMESEC
  GENINS
  VTPLAN

  Just want to get the count of PlanId's that has '-' charector in it (BP-GEN1,BP-MOT1 etc).

  I tried this way..not sure whether this is the right way. not working..

  select count(PlanID) as 'PlanID', CHARINDEX('-', PlanID) from InsDetails where DisId ="INGEN"
  group by PlanID having count(CHARINDEX('-', PlanID) > 0

  Please help me out

  Chithra_Iyer
• • Reply
  

  gimimex

  Participant

  1052 Points

  157 Posts

  Re: Get row count based on CHARINDEX

  Jan 01, 2013 04:32 PM|LINK

  Try:

  select count(PlanID) as 'PlanID'
  from InsDetails
  where DisId = 'INGEN' and
        CHARINDEX('-', PlanID) > 0

  
  Hope this helps.

  http://www.imoveisemexposicao.com.br/imoveis-em-guarulhos
  • Marked as answer by Catherine Shan - MSFT on Jan 08, 2013 05:29 AM