remove / from data in SQL Server
Posted on 2013-12-01
Hello Experts, I have a little problem (some may say a big problem .... but lets not go there); now that we have moved past the innuendo :D I have a field on a MS SQL 2012 table that contains data in to following format:
xx//xxxxxxx or xx/x/xxxxxxxx or A/a/xxxxxxx
the data type is NVARCHAR the values represent cadastral parcels.
my question is how do I remove ONLY / from the field in a view (it is causing some problems when rendering in another application).
Thankyou in advance