When debugging or carrying out impact analysis, it is useful to be able to search for specific text in your SQL Server database. You may wish to see where a specific stored procedure is called from, for example. 286 more words
Tags » CHARINDEX
Have you ever thought of How REPLACE is working? It just replaces all the occurrences of a word in the sentence.
Lets look at an example. 250 more words