Remove Nth character in a string

[bmacbmac]

Hi everyone,

I need to remove the 4th character from Myfield where len(myfield) = 5

I have searched around and surprisingly can't find a way to do this. Any ideas?

Thanks!

 

[gmmastros]

You can use the STUFF function to do this.

Declare @Data VarChar(20)
Set @Data = '12345'

Select @Data, Stuff(@Data, 4, 1, '')

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bmacbmac]

Perfect! And easy.....

Thanks man.