Hi, A am trying to join data opened from XLS with ID's in datatype int with region objects in a native MI table, with ID's as char*4
myXLS has a column iKID (ex = 101) myMI has a column cKID (ex = "0101") - all rows contain 0-9 only Im trying " ... WHERE ... Int(myMI.cKID) = myXLS.iID ... " This Won't work. (Have also tried val(), and val() on both sides. Maybe I'm "blind" here ...) My general question : - Is there a limitation on using conversion functions in the WHERE-clause ? ( If I Add an iKID column in the MI table, use UpdateColumn "... SET iKID = Int(cKID)" and then perform the join, it works, but it is one step more ... ) Rgds, Jon Petter Nielsen Ugland IT Group AS Mail [EMAIL PROTECTED] Phone +47 6759 2818 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16190