Re: ?? on data conversion

In article <41lm43$2ko@jethro.Corp.Sun.COM> yoga@peacetime.Corp.Sun.COM "Yogi Patel" writes: > > How do I convert "char" data into "int" data? > > In detail, I am joining two tables and one table have value in characters > and other table have field in integer format. > > So, I am looking something like: > > where table1.id = ( int? )table2.name Not very advisable as I have found some versions of SQL where trying to join char & int columns falls over unless they are a certain way round in the join. I strongly recommend looking into why the same value is held in two different types of column and seeing if they can be the same - preferably INTEGER. This is also a more space effective way to store the data, and to index. Regards -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================