一段经典的sql语句

实现目的：

在 2025-04-14|2027-04-14|2029-04-14|2031-04-14|2033-04-14
一串字符传中 截取到 第一个日期数据。存入对比列下 2025-04-14
处理方式：

update MainInfo set DiZengDate  = SUBSTRING(DiZengDate,CHARINDEX('|',[DiZengDate])+1,DATALENGTH(dizengdate)- CHARINDEX('|',[DiZengDate])-1)    where Id in ( select Id from MainInfo where dizengThisdatecan < GETDATE() and  CHARINDEX('|',[DiZengDate])>0)
---截取掉第一个数据

update MainInfo set dizengThisdatecan = SUBSTRING(DiZengDate,0,CHARINDEX('|',[DiZengDate]) )   where Id in ( select Id from MainInfo where dizengThisdatecan < GETDATE() and CHARINDEX('|',[DiZengDate])>0)
---获取到第一个日期数据放入参考列

update MainInfo set dizengThisdatecan =  DiZengDate,DiZengDate = ''   where Id in ( select Id from MainInfo where dizengThisdatecan < GETDATE() and  DATALENGTH(DiZengDate)>5)---例如“2033-04-14”只剩下一个数据时比如拷贝后直接清空