text-manipulation functions

本文介绍了一系列常用的文本处理函数,包括从字符串左侧或右侧获取字符、转换大小写、去除空白字符等功能,并详细解释了SOUNDEX算法,该算法可以将文本转换为描述其发音的字母数字模式。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

 

Commonly Used Text-Manipulation Functions

Function

Description

LEFT() (or use substring function)

Returns characters from left of string

LENGTH() (also DATALENGTH() or LEN())

Returns the length of a string

LOWER()

Converts string to lowercase

LTRIM() (LCASE() if using Access)

Trims white space from left of string

RIGHT() (or use substring function)

Returns characters from right of string

RTRIM()

Trims white space from right of string

SOUNDEX()

Returns a string's SOUNDEX value

UPPER() (UCASE() if using Access)

Converts string to uppercase

One item in Table requires further explanation. SOUNDEX is an algorithm that converts any string of text into an alphanumeric pattern describing the phonetic representation of that text. SOUNDEX takes into account similar sounding characters and syllables, enabling strings to be compared by how they sound rather than how they have been typed. Although SOUNDEX is not a SQL concept, most DBMSs do offer SOUNDEX support.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值