Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dev:sql:functions:lj [2010/07/09 20:09]
els
dev:sql:functions:lj [2016/06/28 22:38]
Line 1: Line 1:
-{{page>:​top_add&​nofooter&​noeditbtn}} 
-{{page>:​sql_bar&​nofooter&​noeditbtn}} 
-====== Omnidex SQL Function: $LJ ====== 
-===== Description ===== 
-Left-justify the character expression. 
  
-This function return a C STRING datatype. 
- 
-===== Syntax ===== 
- 
-  $LJ( character_expression ) 
- 
-== character_expression ==  
- 
-Required. ​ Any expression that returns a character-class datatype. ​ Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype.  ​ 
- 
- 
-===== Examples ===== 
-==== Example: Column ==== 
-<​code>​ 
-> select $lj(name) nme from individuals;​ 
- 
-NME 
--------------------------------------------------- 
-MS. MARY LEWIS 
-MRS. ALICE R TOLLIVER 
-MR. SIDNEY K TOLLIVER 
-MRS. JENNIFER J HOPKINS 
-MR. CHARLIE HOPKINS 
-MS. KIMBERLY BLUE 
-KATHLEEN TUCKER 
-</​code>​ 
- 
-====== Additional Resources ====== 
- 
-See also: 
-{{page>​dev:​sql:​functions:​see_also_string&​nofooter&​noeditbtn&​noheader}} 
- 
-{{page>:​bottom_add&​nofooter&​noeditbtn}} 
 
Back to top
dev/sql/functions/lj.txt ยท Last modified: 2016/06/28 22:38 (external edit)