📄 stringfunctions.htm

📁 Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th
💻 HTM
字号:
<html>
<head>
   <title>String Functions</title>
</head>

<!--#include virtual="/inc/header.php"-->


<table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="#FFFFFF">
  <tr>
    <td align="left">
      
<span style="font-family:Helvetica,Arial; font-size:12pt; color:#000000"><b>String Functions
<br>
</b></span>
    </td>
    <td align="right">
     <font face="Arial" size="2">
     <a href="stringconcatenationoperator.htm">Previous</a>&nbsp;
     <a href="overview.htm">Top</a>&nbsp;
     <a href="arithmeticfunctions.htm">Next</a>
     </font>
    </td>
  </tr>
</table>
<br><br>



<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
Absolute Database supports the following string functions:
<br>

<br>
<table border="0" cellpadding="1"><tr><td align="left" valign="top" width="83">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b><u>Function</u></b>
<br>
</span></td><td align="left" valign="top" width="360">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b><u>Description</u></b>
<br>
</span></td></tr><tr><td align="left" valign="top" width="83">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">LOWER
<br>
</span></td><td align="left" valign="top" width="360">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Converts string to lower case
<br>
</span></td></tr><tr><td align="left" valign="top" width="83">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">UPPER
<br>
</span></td><td align="left" valign="top" width="360">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Converts string to upper case
<br>
</span></td></tr><tr><td align="left" valign="top" width="83">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">SUBSTRING
<br>
</span></td><td align="left" valign="top" width="360">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Extracts substring 
<br>
</span></td></tr><tr><td align="left" valign="top" width="83">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">POS
<br>
</span></td><td align="left" valign="top" width="360">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Location of specified substring
<br>
</span></td></tr><tr><td align="left" valign="top" width="83">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">LENGTH
<br>
</span></td><td align="left" valign="top" width="360">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Number of characters in string 
<br>
</span></td></tr><tr><td align="left" valign="top" width="83">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">LTRIM
<br>
</span></td><td align="left" valign="top" width="360">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the string with leading space characters removed
<br>
</span></td></tr><tr><td align="left" valign="top" width="83">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">RTRIM
<br>
</span></td><td align="left" valign="top" width="360">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the string with trailing space characters removed
<br>
</span></td></tr><tr><td align="left" valign="top" width="83">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">TRIM
<br>
</span></td><td align="left" valign="top" width="360">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the string with leading and trailing space characters removed
<br>
</span></td></tr></table>
<br>

<br>

<br>
<b>LOWER (string_exp) </b>
<br>
<span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns a string equal to that in string_exp with all uppercase characters converted to lowercase.
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">LOWER('TOM')&nbsp;returns&nbsp;tom
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000"></span></td></tr></table><span style="font-family:Courier New; font-size:8pt; color:#000000"></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>UPPER (string_exp) </b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns a string equal to that in string_exp with all lowercase characters converted to uppercase.
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">UPPER('tom')&nbsp;returns&nbsp;TOM</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>

<br>
<b>SUBSTRING (string_exp, start [, length])</b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns a character string that is derived from string_exp beginning at the character position specified by start for length characters.
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">SUBSTRING("ABCDE",&nbsp;4,&nbsp;2)&nbsp;returns&nbsp;DE</span><span style="font-family:Times New Roman; font-size:12pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Times New Roman; font-size:12pt; color:#000000"></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span><span style="font-family:Times New Roman; font-size:12pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>POS (substring_exp, string_exp)
<br>
</b></span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the position of the first character expression in the second character expression. 
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">POSITION('CDE','ABCDEFG')&nbsp;returns&nbsp;3</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>

<br>
<b>LENGTH (string_exp) </b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the number of characters in string_exp.
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">LENGTH('ABCEDFG')&nbsp;returns&nbsp;7</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>

<br>
<b>LTRIM (string_exp) </b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the characters of string_exp, with leading blanks removed.
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">LTRIM('&nbsp;Tom')&nbsp;returns&nbsp;Tom</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>

<br>
<b>RTRIM (string_exp) </b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the characters of string_exp, with trailing blanks removed.
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">RTRIM('Tom&nbsp;')&nbsp;returns&nbsp;Tom</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>

<br>
<b>TRIM (string_exp) </b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the characters of string_exp with leading and trailing space characters removed.
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">TRIM('&nbsp;Tom&nbsp;')&nbsp;returns&nbsp;Tom</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span>

<!--#include virtual="/inc/footer.php"--> 
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -