The first 119 Chapter SQL function RIGHT

Scalar string function , It starts at the end of the string expression （ The rightmost position ） Returns a specified number of characters .

The outline

{
    fn RIGHT(string-expression,count)}

Parameters

• string-expression - String expressions , It can be a column name 、 String literal or the result of another scalar function , The basic data type can be expressed as any character type （ for example CHAR or VARCHAR）.
• count - Integers , Specify from string-expression The end of （ Far right ） Number of characters returned from position .

describe

RIGHT From the end of the string expression （ The rightmost position ） return count Characters . If you pass... For any parameter NULL value ,RIGHT Will return NULL.

RIGHT Can only be used for ODBC Scalar function （ Use brace Syntax ）.

Example

The following example returns Sample.Person The rightmost two characters of each name in the table ：

SELECT Name,{fn RIGHT(Name,2)}AS MiddleInitial
     FROM Sample.Person

The following embedded SQL The example shows RIGHT How to handle a count longer than the string itself ：

/// d ##class(PHA.TEST.SQLFunction).Right()
ClassMethod Right()
{
    
	&sql(
		SELECT Name,{
    fn RIGHT(Name,40)}
			INTO :a,:b
		FROM Sample.Person
	)
	if SQLCODE '= 0 {
    
		w !,"Error code ",SQLCODE 
	} else {
    
		w !,a,"=original",!,b,"=RIGHT 40" 
	}
}

DHC-APP> d ##class(PHA.TEST.SQLFunction).Right()
 
Adams,Diane F.=original
Adams,Diane F.=RIGHT 40

Do not perform population .