zhangxinba 发表于 2016-11-9 04:44:23

SQL截取字符串

  

Mysql:

http://www.iyunv.net/article/27458.htm


Oracle :

SELECT SUBSTR('abcdefg',2,5) FROM DUAL
结果 bcdef
Sql Server:
SELECT SUBSTRING('abcdefg',2,5)
结果 bcdef
  
页: [1]
查看完整版本: SQL截取字符串