Progress
SQL-92
Guide and Reference


CONCAT Function

Returns a concatenated character string formed by concatenating argument one with argument two.

SYNTAX

CONCAT ( char_expression , char_expression ) 

EXAMPLE

This example illustrates the CONCAT function:

SELECT last_name, empno, salary 
    FROM customer 
    WHERE project = CONCAT(’US’,proj_nam); 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095