Difference between revisions of "STRTOUPPER()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Class== | ==Class== | ||
| − | + | String Data | |
==Purpose== | ==Purpose== | ||
| − | + | Function to convert character expression to upper case | |
==Syntax== | ==Syntax== | ||
| − | + | STRTOUPPER(<expC>) | |
==See Also== | ==See Also== | ||
| − | + | [[DESCEND()]], [[ISLOWER()]], [[ISUPPER()]], [[LOWER()]], [[PROPER()]], [[STRTOLOWER()]], [[UPPER()]] | |
==Description== | ==Description== | ||
| − | + | The STRTOUPPER() function converts a character expression, <expC>, to upper case. This function is particularly useful with index expressions, as when the FIND key is pressed in forms, a search string typed in upper case will match both upper and lower case characters stored in the table. | |
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | ? strtoupper("Recital") | |
| + | RECITAL | ||
</code> | </code> | ||
| − | |||
| + | ==Products== | ||
| + | Recital Database Server, Recital Mirage Server, Recital Terminal Developer | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:String Data]] | ||
| + | [[Category:String Data Functions]] | ||
Revision as of 11:09, 13 October 2009
Class
String Data
Purpose
Function to convert character expression to upper case
Syntax
STRTOUPPER(<expC>)
See Also
DESCEND(), ISLOWER(), ISUPPER(), LOWER(), PROPER(), STRTOLOWER(), UPPER()
Description
The STRTOUPPER() function converts a character expression, <expC>, to upper case. This function is particularly useful with index expressions, as when the FIND key is pressed in forms, a search string typed in upper case will match both upper and lower case characters stored in the table.
Example
? strtoupper("Recital") RECITAL
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
