×
Menu
Search
 
   
   
   
 

String functions

The following is a list of String functions in MapAble:
Each function has a link to more detailed descriptions and applications.  The ones used often in the GIS environment has short descriptions.
 
String
 
ASCII()
 
 
LTRIM(Character_Expression)
 
Function
Returns a character expression after it removes leading blanks.
Use
In the case of blank spaces before the text
 
CHAR(Integer_Expression)
 
Function
Converts an ASCII code to a character.
Use
To change a number field to an alphanumerical string
 
SPACE(Integer_Expression)
 
Function
Returns a string of repeated spaces.
Use
To include spaces
 
CHARINDEX ( )
 
 
CONCAT ( string_value1, string_value2 [, string_valueN ] )
 
Function
Returns a string that is the result of concatenating two or more string values.
Use
To combine several other string fields into one
 
QUOTENAME()
 
 
STUFF()
 
 
DIFFERENCE()
 
 
REPLACE ( string_expression , string_pattern , string_replacement )
 
Function
Replaces all occurrences of a specified string value with another string value.
Use
To replace the values of one text field with another text field
 
SUBSTRING ( expression ,start , length )
 
Function
Returns part of a character, binary, text, or image expression in SQL Server.
Use
To take part of a text string in add to a the new field
 
FORMAT()
 
 
REPLICATE ( string_expression ,integer_expression )
 
Function
Repeats a string value a specified number of times.
Use
As above
 
LEFT ( character_expression , integer_expression )
 
Function
Returns the left part of a character string with the specified number of characters.
Use
As above
 
REVERSE ( string_expression )
 
Function
Returns the reverse order of a string value.
Use
As above
 
UPPER ( character_expression )
 
Function
Returns a character expression with lowercase character data converted to uppercase.
Use
As Above
 
PROPERCASE ( string_expression )
 
Function
Returns a character expression with lowercase or uppercase character data converted to proper case.
Use
When data is required to be uppercase
 
LEN ( string_expression )
 
Function
Returns the number of characters of the specified string expression, excluding trailing blanks.
Use
As above
 
RIGHT ( character_expression , integer_expression )
 
Function
Returns the right part of a character string with the specified number of characters.
Use
For example the last part of a property code or number
 
LOWER ( character_expression )
 
Function
Returns a character expression after converting uppercase character data to lowercase.
Use
As above
 
RTRIM ( character_expression )
 
Function
Returns a character string after truncating all trailing blanks.
Use
As above