Plz if ne1 knows how to convert rows into columns ie to use Pivot tell me.I m using the DBArtisan tool for accessing the Sybase server.