Help with getting upper into lower case

• faulknerwilliam2

  SSCrazy

  Points: 2299

  More actions

  March 24, 2015 at 2:59 am

  #398227

  Hello

  In my SELECT statement, I have:

  ,UserName

  When this comes through in the query, it appears as: JOHN.SMITH

  Is it possible to use CAST or CONVERT to change this to John Smith?

  Any advice gratefully appreciated.

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  March 24, 2015 at 3:24 am

  #1785893

  check following link.

  Hope it helps.