Is there a way to sort on a VarChar column or convert the column to a sortable column? I tried this: R>lis col keywordtext Column Name Table Name Attributes ------------------ ------------------ --------------------------------------- KeyWordText TextColumns Type : TEXT 40 R>create temp view tvKeyWord (KeyWordText) as select (ctxt(keyword)) from keyword R>select keywordtext, count(*) from tvkeyword group by keywordtext and get -ERROR- Cannot SORT on an item with a data type of VARCHAR (2313) _________________________________________________________________ Get in touch in an instant. Get Windows Live Messenger now. http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_getintouch_042008
