在access的sql语句中如何实现类似oracle中replace函数功能?
ken16 2003-02-10 05:53:05 我找到了一个,但是里面提供的方法好像不行。
http://pub52.ezboard.com/finteractivepsybertechnologydevelopersgroupfrm36.showMessage?topicID=68.topic
Select field1 from table
Order by Mid(replace(field1,"-",""),len((replace(field1,"-","")-1),2)