I have a customer that has two AOD companies that have a ID field with the same series of numbers in them.  In order to not overwrite one set of records from the second set of records, I want to add a string to the data in the ID field.

This is what I have tried to do:

SELECT "'RW' + CONVERT(Profile_ID, SQL_CHAR (10))" AS Profile_ID

I have also tried:

SELECT "'RW' + CAST(Profile_ID AS nvarchar (10))" AS Profile_ID

 Both of these cause an error with the ODBC driver for PSQL saying the there is an invalid column:

Detail: ERROR [HY000] [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Error in expression: 'RW' + CAST(Profile_ID AS nvarchar (10))
ERROR [42S22] [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Invalid column name: ''RW' + CAST(Profile_ID AS nvarchar (10))'.

This seems like it should be a simple thing.  Any guidance? 

 Thanks!

Mike Kokinda

CONVERT should not have a length associated with the data type. 
CAST should not have SQL_ in front of the datatype.  Also, it needs to be either CHAR, VARCHAR, or LONGVARCHAR.

These statements worked correctly:

select * from mike;

SELECT 'RW' + CONVERT(Profile_ID, SQL_CHAR) as Profile_ID from mike;

SELECT 'RW' + CAST(Profile_ID AS VARCHAR(10)) as Profile_ID from mike;

Thanks Linda, the import did work with the exception that it brought in Data twice.  Once with the RW string added to the Profile_ID data and then again with out the RW.  I have to pull apart the entire import to see where the second set of data comes in at....

 I appreciate the help.  It seems the nvarchar was the problem with my previous attempts.

Koke (Mike)