Problems casting memo to varchar fields.
I have a issue in a select statment where I cast a memo to varchar it seems unless I set the varchar limit to the max field lenght of the memo field it sets itself to a value that cuts off the rest of the data.
My question is does the varchar have a default size setting or is just using the first value it displays in the result set to be its setting ? Or is there some other reason and it there anyway around it but a seperate querie to get the max field lenght of the memo field ?
Andrew.
