I have to tables I would like to join on t1.[alarmno] and t2.[address]
t1.[alarmno] is a int field - containing int values
t2.[address] is a varchar(2) - containing hex values like 0D, 1F, FF.
I have not been able to convert/cast the values in any way so that the can be "compared".
I have tried this
top 100 alarmno,