I have can access a table in an external MS SQL database. I figure this because I can enter "LIST MyTableName" and 76 column names come up. I'm using the R> prompt interface.
If I enter at the R> prompt: SELECT InsuredID NamedInsured State FROM MyTableName WHERE NamedInsured CONTAINS 'MANHAVE' The output is only two columns: InsuredId and NamedInsured, the State column doesn't even show in the header. It doesn't matter what other columns I request, I only get the first two, whatever they might be. Using SELECT * only gives me two and there are 76 of them. What am I doing wrong? Thank you. --- Hans Manhave Operations Director Jackson-Lloyd Ins P.O.Box 187 Longview, TX 75606 903-758-6206
