Updating Part of Filename

• Jonathan Marshall

  SSCrazy

  Points: 2633

  More actions

  March 27, 2013 at 10:08 am

  #275638

  Hello Everyone,

  What would be the best way to go about converting a part of this Filename from upper case to lower case?

  FROM: APR0111OFR_AAAAAAAA_01

  TO: Apr0111OFR_AAAAAAAA_01

• Erin Ramsay

  SSCrazy Eights

  Points: 9728

  More actions

  March 27, 2013 at 10:21 am

  #1601246

  Something like this?

  declare @filename varchar(255)

  set @filename = 'APR0111OFR_AAAAAAAA_01'

  select replace(@filename, substring(@filename,2,2),lower(substring(@filename,2,2)))

• Seraj Alam-256815

  SSC Eights!

  Points: 804

  More actions

  March 27, 2013 at 10:32 am

  #1601251

  I do not know what is your exact requirement, however, this piece of code may help you.

  declare @from varchar(50) , @to varchar(50)

  select @from = 'APR0111OFR_AAAAAAAA_01'

  select @to = stuff(@from,2,2, lower(substring(@from,2,2)))

  Print @to

  -----

  Seraj Alam

  Return to scociety from where you received a lot.

• Jonathan Marshall

  SSCrazy

  Points: 2633

  More actions

  March 27, 2013 at 11:17 am

  #1601276

  Thanks so much guys this is greatly appreciated....