菜鸟提问了

[donghb8]

36.00(套CNY
200.00(全套五
93(套￥30.80
11.90(套CNY
720.00(全套)
11.90(套CNY
93(套￥30.80
93(套￥30.80
460.00(全套)
11.90(套CNY
00(套￥85.00
14.80(套CNY

只要前面的价格,(以后不要,谢谢!!!

[wxyq]

select to_char('720.00','999999999.00') from dual

[zarge]

select left( yourcol, charindex( '(', yourcol ) - 1 ) from yourtable

[donghb8]

还有没有其他的办法喃

[wxyq]

select SUBSTRB('720.00(套CNY',1,INSTR ('720.00(套CNY','(')-1)from dual