摘要:
1、大小写转换:UPPER(exp)、LOWER(exp)SELECT UPPER('abc')> ABCSELECT LOWER('AbC')> abc2、字符串查找:CHARINDEX( exp_find , exp_src [ , start_location ] )SELECT CHARINDEX('de','abcdefghijklmn')> 4//exp_src索引下标从1开始,找不到则返回03、字符串截取:SUBSTRING ( exp, start, length )SELECT SUBSTRIN 阅读全文