Shulou(Shulou.com)06/01 Report--

This article mainly shows you "how sql separates data from both sides with arbitrary symbols". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "how sql separates data from both sides with arbitrary symbols".

Separate the data on both sides with any symbol

For example, if we split the data with a comma (,), we would have the following data

It is divided into the following figure:

SELECT Rmaine case WHEN CHARINDEX (',', R) > 1 THEN LEFT (RMagna CHARINDEX (',', R)-1) ELSE NULL END AS R1, CASE WHEN CHARINDEX (',', R) > 1 THEN RIGHT (R, (LEN (R)-CHARINDEX (',', R) ELSE NULL END AS R2FROM t

The code is long, so we split the code to understand:

SELECT CHARINDEX (',')-- the result is 1SELECT CHARINDEX (',', 'NULL')-- the result is 0SELECT CHARINDEX (',',')-- the result is 0SELECT CHARINDEX (',','A,')-- the result is 2SELECT LEN ('A,')-- the result is 3SELECT LEN ('A,')-CHARINDEX (',','A')-- the result is 3-2=1SELECT RIGHT ('A,',') B')-CHARINDEX (',','A _ MagneB'))-- the result is B.

In the last step, we split the'A ~ ~ B 'out of B, and we can get it in a similar way.

The above is all the contents of the article "how sql separates data on both sides with arbitrary symbols". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.