Between first letter in last name (WHERE clause)

• stricknyn

  SSCertifiable

  Points: 6560

  More actions

  October 12, 2009 at 2:15 pm

  #139531

  Hi All,

  Not sure if this can be done in T-SQL but I was curious if there is a way to filter on a range based on the the first letter in the last name. So basically I want to get everything where the last name between A and M. then N and Z. Something like:

  WHERE P.LAST_NAME BETWEEN LIKE 'A%' AND LIKE 'M%'

  Of course this doesn't work, but just wanted to show what I'm attempting to do.

  Thanks,

  Strick

• Garadin

  One Orange Chip

  Points: 29613

  More actions

  October 12, 2009 at 2:24 pm

  #1064925

  WHERE LEFT(LastName,1) BETWEEN 'A' AND 'M'

  Seth Phelabaum

  ---

  Consistency is only a virtue if you're not a screwup. 😉

  Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

• Piotr.Rodak

  SSCrazy Eights

  Points: 9376

  More actions

  October 12, 2009 at 2:26 pm

  #1064926

  Try this:

  select * from person.contact where LastName like '[A-N]%'

  Regards

  Piotr

  ...and your only reply is slàinte mhath

• stricknyn

  SSCertifiable

  Points: 6560

  More actions

  October 12, 2009 at 3:21 pm

  #1064953

  Great! thanks guys

  Strick