Hi,

I have table in SQL Server that has column with data type Uniqueidentifier.

I created synonym in data migrator for same table, data type is A38 Fixed. But when I see values that values included {}.

In SQL : 72951DA9-B1B6-E411-8C7F-0050560E00AE
IN DM Synonym : {72951DA9-B1B6-E411-8C7F-0050560E00AE}

Any idea ?
How to remove {} from DM Synonym.

Thanks,

This message has been edited. Last edited by: Tamra,

This has been addressed in 8.2 through the use of the new MS ODBC driver.

However for the nonce you can create a DEFINE in the synonym

XID/A36=SUBSTRING(UID,2,36)

Thank You, Cliff