accessÖÐreplaceÎÊÌâ

ÎÒÓÐÒ»¸öUnits±í,½á¹¹Îª:
  ID              UnistsName
  UN1            ºÚÁú½­¶«·½Ñ§Ôº
  UN2            ÖйúÒƶ¯Í¨Ðż¯ÍźÚÁú½­ÓÐÏÞ¹«Ë¾
  UN3            Áìµ¼¸É²¿ÃñÖ÷²âÆÀ(¼ò)
ÎÒдÁËÒ»¸ö²éѯÓï¾ä:select  ID,UnitsName  from Units  order by (replace(Ltrim(Rtrim(ID)),'UN','')+0)
Õâ¸öÓï¾äÊÇ°´"UN"ºóÃæµÄÊý×Ö´óСÅÅÐò.
ÎÊÌâÊÇÕâ¸öÓï¾äÎÒÔÚaccessÖеIJéѯÖÐÔËÐÐûÓÐÎÊÌâ,µ«ÊÇÔÚ OleDbDataAdapter ÖÐÒ»Ö±ÐоÍ˵:
"±í´ïʽÖÐ 'replace' º¯Êý䶨Òå".ÕâÊÇΪʲô?

ÕâÊÇÖ´ÐÐÕâ¸ö²éѯÓï¾äµÄ·½·¨:
        public static DataSet Query(string SQLString)
        {
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                DataSet ds = new DataSet();
                try
                {
                    connection.Open();
                    OleDbDataAdapter command = new OleDbDataAdapter(SQLString, connecti