select

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  April 20, 2009 at 12:30 pm

  #133067

  how would i select a name that has 2 letters after uner score at the end.

  something like

  BugdetRev120909_PA

  SirsregionRev_CA

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 20, 2009 at 12:44 pm

  #980964

  Do some reading in BOL on the LIKE operator and wildcards.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 20, 2009 at 12:49 pm

  #980966

  How about this:

  SELECT

  *

  FROM

  TABLE

  WHERE

  LEN(column) - CHARINDEX('_', 'column') = 2

  Or

  SELECT

  *

  FROM

  TABLE

  WHERE

  Column LIKE '%/___' ESCAPE '/'

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Mohan Kumar VS

  SSCommitted

  Points: 1724

  More actions

  April 29, 2009 at 5:18 am

  #985790

  Tara

  Hope this will be helpful....

  -- Create Tmp Table

  create table #tmp1 (firstname varchar(100))

  -- Insert records

  insert into #tmp1 values ('BugdetRev120909_PA')

  insert into #tmp1 values ('SirsregionRev_CA')

  insert into #tmp1 values ('BugdetRev120909_PAxxx')

  insert into #tmp1 values ('SirsregionRev_CAxxx')

  -- Fetch records for matching criteria

  select * from #tmp1 where substring(firstname, len(firstname)-2,1) = '_'

  Rgds

  Mohan Kumar Vs