第1个回答 2010-05-14
用substr函数,参数说明是:substr( string, start_position, [ length ] )
如:
substr('This is a test', 6, 2) would return 'is'
substr('This is a test', 6) would return 'is a test'
substr('TechOnTheNet', 1, 4) would return 'Tech'
第2个回答 2010-05-14
substr(数据对象,1,length(数据对象) - 3)
例如:
substr('A21.SMZXI/ZG01/01',1,length('A21.SMZXI/ZG01/01') - 3)本回答被提问者采纳