CAST or CONVERT 
or STR depends upon which way you want to go.

 

  Ben Dean <ben.dean@t...> wrote: i need to change a number stored as a string into something i can compare 
with another number. here is the where statement from my query as an 
example:

WHERE table1.partn = table2.partn

the only problem is that table1.partn is a string and table2.partn is some 
sort of number. can't compare them