Shulou(Shulou.com)05/31 Report--

This article shows you how to use the Replace keyword, which is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

In sql server, the Replace keyword is mainly used to replace a character in a string with another character. Today, if you want to think in reverse, it can also be used to query whether it contains a specific string. For example, given that the following dataset expects to get records containing "aaa" characters from this dataset, note that the second piece of data does not contain "aaa", but contains "aaaa". The expected result is as follows: the traditional way of thinking must be to find out how to find a string containing three a, some people will use like, but this will also be found along with four a. Here we are thinking about replacing the "aaa" in the string with Replace. If it can be replaced, it will prove that the string contains this character. After replacing it, it will certainly be different from the original string, so there is the following SQL. The copy code is as follows: SELECT * FROM [master]. [dbo]. [Table_5] WHERE REPLACE (','+ strNum+',',', aaa,','')','+ strNum+','

The above is how to use the Replace keyword. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.