有LEFT(),RIGHT(),LOWER(),UPPER(),LTRIM(),RTRIM(),LENGTH(),SOUNDEX()函数。
SOUNDEX()是一个将任何文本转换为描述其语音表示的字母数字模式的算法。比如:
SELECT
cust_name,cust_contact
FROM Customers
WHERE SOUNDEX (cust_contack) = SOUNDEX ( ' Michael Green ' )
FROM Customers
WHERE SOUNDEX (cust_contack) = SOUNDEX ( ' Michael Green ' )