Joining Different Data Types

[Cynthia]

I have an Access Database that I have to use as one of my Data Sources.  It's created and updated by an external application so I can't change it in any way.  I've created a query subject that joins 2 Access Tables in my Framework.

I need to join an Employee Number field from one of the Access tables, to an Employee Number field in a Sybase Table.

The datatype of the Access DB is a memo, which Framework Manager is interpreting as a text/blob.  And the datatype of the field in Sybase is an Int32. 

Needless to say FM doesn't want to link these two fields. How can I go about getting the relationship to work and the Framework to verify?  I've tried to Cast the Access field to Integer in the Query Subject's SQL, but that is giving me an error too.

I'd appreciate help. Thanks!

[Cynthia]

When I try to use CAST in the SQL that selects the field from the Access table, I get this error:

UDA-EE-0094 The operation "cinteger" is invalid for the following combination of data types: "textblob" and "integer"

Hrmph.

[MFGF]

You might have better luck trying to cast the Sybase column as text?  Worth a shot...

MF.

[jive]

Hi,
Or you can do the conversion in Access,add a column in a view and transform the value

regards Jacques