Either use STRCONV(,6) on the memo field in the view or use CAST() function in the SELECT to convert from UNICODE to ANSI.
>Oh, I see. But I'm not sure I understand how to implement your suggestion. I tried "Select strconv(email,6) from rvCustomer" but I still only get the first character of whatever's in the field. Should I be using STRCONV() in conjunction with something else? I don't know how to do this.
>
>>There're no memo data types in the MS SQL Server. A text data can be stored in numerous character data types:
>>ANSI - char, varchar, text
>>UNICODE - nchar, nvarchar, ntext
>>
>>Based on your description, it's one of Unicode character data types. You can use STRCONV(,6) to conver Unicode data to ANSI.
--sb--