SQL - Select and Replace Syntax
Posted on 2015-02-12
I have a bunch of PDF drawings that are listing in a BRIDGEPHOTO Table in SQL Server 2012 , Problem is some of the pdf names include the "&" symbol. This is a reserved word in ESRI and the attachments are not working.
I would just like to Delete that from the name all together.
So Plan&Profile becomes PlanProfile or Plan_Profile
I can replace with and "_" as well. Either way is good with me.
SELECT REPLACE(AliasName,'&', '')
Where AliasName Like '&'
I'm not sure if this is right and was hoping to double check, Plus get some feedback on the best way to do this.