conversion of an integer to string in SQL query

Discussion created by mfrancis_CoServ on Sep 25, 2012
Latest reply on Sep 27, 2012 by fabl
Hey All,

I am joining a table to my SQL database, and trying to determine if two values are equal, but I am having a hard time with this comparison

database.testing.PARCELS.PID <> PARCELS_SpatialJoin1.PID

The first value is text, the second is an integer.  In the Select By Attributes dialog box, how do I make this work?