substring(xx,start_index,end_index) //获取字符串xx从start_index到end_index的子串
instr(xx,aa,start_index,end_index)//定位,从字符串xx中查找aa,查找范围从start_index到end_index,如果start_index为-1,表示反向查找定位
lower(xx)//变成小写
upper(xx)//变成大写
length(xxx)//求长度
###############################################
待续!!