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).
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…