Memo Data Type on the Microsoft Server

NBoddie 1 Reputation point
2021-04-14T21:30:18.357+00:00

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

87908-image.png
87933-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,809 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,558 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2021-04-15T15:18:03.463+00:00

    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

    0 comments