ascii(求字符的ascii值),char(根据ascii转到字符),
left,right,substring:字符串截取
len:返回字符串的长度
lower,upper:转小写、大写
ltrim,rtrim:去空格
注意:索引从1开始,而不是0
select *,LEN(sname)
from studentinfo
select *,DATALENGTH(sname)
from studentinfo
select *,substring(sphone,2,4)
from studentinfo
select ltrim(sphone)
from studentinfo
select rtrim(sphone)
from studentinfo
select left(sphone,3)
from studentinfo
select right(sphone,3)
from studentinfo