I am completely new to T-SQL and I am learning how to do some complex stuff.
I have a table called TA with columns ServerName, TextA
Table Name : TA
columns 1: Server name
column 2: TextA
in the column "ServerName" I have listed server names like
I need to update the column Servername such a way that I need to remove anything with ".disc.dim.com",".dim.com","st.dim.com"
I tried using replace function but that doesn't seem to help.
Any guidance is much appreciated.