SQLSERVER字符串截取------REVERSE

 1 REVERSE
 2 
 3 能把一个字符串倒过来
 4 
 5 sql中的reverse功能  
 6 要把用户电话号码中,倒数第三位是2,倒数第二位是6,最后一位是偶数的号码列出来
10 insert @tab values('13456434353')
16 
17 
18 select * from @tab where substring(REVERSE(tel),3,1)=2
19 select * from @tab where substring(REVERSE(tel),3,1)=2 and substring(REVERSE(tel),2,1)=6
20 
21 select * from @tab where substring(REVERSE(tel),3,1)=2 and substring(REVERSE(tel),2,1)=6
22 and substring(REVERSE(tel),1,1)%2=0
23 
24 取得尾三联及以上的号码:
25 
26 select * from xingming where substring(reverse(tel),2,1)=substring(reverse(tel),1,1)
27 and substring(reverse(tel),2,1)=substring(reverse(tel),3,1)
28 
29 提取IP:192.168.37.39
30 
31 select reverse(left(reverse(ip),charindex('.',reverse(ip))-1)) from cs
32 
33 结果:39

 

转载于:https://www.cnblogs.com/xiaodaidu/archive/2013/04/04/2999429.html