DBMS函数在字符删除中的应用

DBMS Functions in the Application to Delete Characters

在数据库操作中有时需要将记录的无关字符去除,不同DBMS提供了不同的字符处理函数。合理地利用这些函数,能够实现一些超出函数本身的应用。文中以SQLServer为例,展示了字符处理函数的使用技巧。

Operation in the database records sometimes need to remove extraneous characters, Different DBMS has provided us with different function to deal with characters. If these functions can be used reasonably, you can achieve a number of applications beyond the functions itself. Taking SQL Server as an example in this article ,in order to demonstrate the use of function skills to deal with characters.