This should be easy for some of the super users.  I need to link two tables, in one table the field is a string and the other it is a number.  I know you have to use an SQL statement in the Add Command region of the Database expert.  I am a bit fuzzy on the exact procedure though.  Do a need to create a new table with a converted field?  What syntax would be needed?  I have no other way to link the tables.  In Access I would create a query with a expression field of the converted number to string, and run the report from the query. 

Hi,  Could you please give more detail and/or an example of this?  I'm trying to link INDIVIDUALID (number data type) with alternate_id_1txt (string data type).  These tables are from two different DB's.  So I'm getting the warning 'More than one database driver has been used in this report.  If you want to change the database drivers use Database/Set Location.  Please make sure that no SQL Expression is added and no server-side group-by is performed.'  Will that be a problem?