Difference between revisions of "LTOS()"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to convert logical to string | Function to convert logical to string | ||
| − | |||
==Syntax== | ==Syntax== | ||
LTOS(<expL>) | LTOS(<expL>) | ||
| − | |||
==See Also== | ==See Also== | ||
[[CAST()]], [[DTOC()]], [[DTOS()]], [[STR()]], [[STRZERO()]], [[TYPE()]] | [[CAST()]], [[DTOC()]], [[DTOS()]], [[STR()]], [[STRZERO()]], [[TYPE()]] | ||
| − | |||
==Description== | ==Description== | ||
The LTOS() function returns the logical expression <expL> as a character string "T" or "F". It is particularly useful for building indexes on mixed data types. | The LTOS() function returns the logical expression <expL> as a character string "T" or "F". It is particularly useful for building indexes on mixed data types. | ||
| − | |||
==Example== | ==Example== | ||
| Line 19: | Line 15: | ||
index on ltos(married)+upper(name) to married | index on ltos(married)+upper(name) to married | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 12:57, 11 December 2012
Purpose
Function to convert logical to string
Syntax
LTOS(<expL>)
See Also
CAST(), DTOC(), DTOS(), STR(), STRZERO(), TYPE()
Description
The LTOS() function returns the logical expression <expL> as a character string "T" or "F". It is particularly useful for building indexes on mixed data types.
Example
index on ltos(married)+upper(name) to married
Products
Lianja Server, Lianja
