两种表示，都是一样的
- 1.TRIM([ { (LEADING | TRAILING | BOTH)[ trim_character ] | trim_character } FROM ] trim_source )
2. trim([leading | trailing | both] trim_char from string)
For example:
trim(' tech ') would return 'tech'
trim(' ' from ' tech ') would return 'tech'
trim(leading '0' from '000123') would return '123'
trim(trailing '1' from 'Tech1') would return 'Tech'
trim(both '1' from '123Tech111') would return '23Tech'
295
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
