- 论坛徽章:
- 71
|
本帖最后由 zhaopingzi 于 2012-02-28 16:32 编辑
try:
- select mo,substring(cell,0,len(cell)-1) as cell from TRX12
复制代码
- 1> select mo,substring(cell,0,len(cell)-1) from test
- 2> go
- mo substring(test.cell,0,len(test
- --------------- ------------------------------
- RXOTRX-242-4. CDC048B
- (1 row affected)
- 1> select * from test
- 2> go
- mo cell
- --------------- -------------
- RXOTRX-242-4. CDC048B.
- (1 row affected)
- 1> select mo,substring(cell,0,len(cell)-1) from test
- 2> go
- mo substring(test.cell,0,len(test
- --------------- ------------------------------
- RXOTRX-242-4. CDC048B
- (1 row affected)
- 1>
复制代码 |
|