• Thanks to all I found the problem,

    in sql 2000 numeric values are not implicitly converted to characters within a string concatenation statment