i have followed the examples in README.tsearch about converting text columns to txtidx type using the function txt2txidx() . Problem is.. some words become chopped. "Database for dummies" becomes 'dummi' 'databas' , for example. whats goin on here. anything i missed? i also created a trigger to update the txtidx column and it does the samething. thanks - bruce
__________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]