Memo Data Type on the Microsoft Server

Question

I have created a view on the server and its making the data type a memo. I am trying to use this view in Crystal report and it will display with that data type. Can you help with convert this data type to something else?

Here is the query in the view"
SELECT JobNumber, UserText, LEFT(UserText, 100) AS UserTextGroup
FROM dbo.AJ_D40

Answer 1

This is a Crystal Reports question, not a SQL Server question.

Please see:
https://answers.sap.com/questions/12748250/crystal-report-converting-the-nvarcharmax-datatype.html