Problems casting memo to varchar fields. 
Author Message
 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.



Tue, 14 Sep 2004 00:10:08 GMT
 Problems casting memo to varchar fields.

Quote:
>> I have a issue in a select statment where I cast a memo to varchar

What is 'memo'?  Do you mean Access?  There is no such datatype in SQL
Server.

www.aspfaq.com



Tue, 14 Sep 2004 00:23:35 GMT
 Problems casting memo to varchar fields.
Sorry meant text.


Quote:
> >> I have a issue in a select statment where I cast a memo to varchar

> What is 'memo'?  Do you mean Access?  There is no such datatype in SQL
> Server.

> www.aspfaq.com



Tue, 14 Sep 2004 00:51:06 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. cast problem -- int to varchar

2. SQL problem:cast from VARCHAR to TEXT

3. Count occurences of several string in a Memo (VARCHAR(5000) field

4. How to put carriage return into memo/varchar field

5. SQL: memo field is VarChar?????

6. PROBLEMS INSERTING MEMO FIELDS FROM TABLE FIELD TO TEXT FILE

7. CASTing varchar to float issue

8. Stopping errors when casting from varchar to int

9. Cast int to varchar in Tsql?

10. Cast decimal to varchar

11. Can CAST(Varchar AS Numeric) return 0?

12. cast varchar into money


 
Powered by phpBB® Forum Software