Linking tables with different data types

[smilbert]

Using CRXI and MS SQL Svr 2000

I'm trying to compare data in two different databases. There is a common value, however, one vendor stores it as a number and the other a string.

Other than a SUB-REPORT (very slow), is there any way to add this table and LINK with a formula (ToStr(X))??

TIA

 

[Kendel]

You can use command line, something like:

Select * from table1 inner join table2 on table1.field = ToStr(Table2.field)