LEN function

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  April 29, 2012 at 2:37 pm

  #1480978

  Here this works for me.

  SELECT Name,REVERSE(right(REVERSE(Name),12)) from sys.databases

  model model

  msdb msdb

  Test5K Test5K

  AdventureWorks AdventureWor

  Test5K_snapshot Test5K_snaps

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]