Hello!!
I need some help to convert a memo field in SQL Server, progress see it as longvarbinary (character), into a text or string.
Sql function to do it:
SELECT
[SRM].[R_E_C_N_O_],
ISNULL(CONVERT(VARCHAR(1024),CONVERT(VARBINARY(1024),[alias].[memoField])),'') AS [MEMO]
FROM
[table] [alias] WITH (NOLOCK)
I need to do it in 4GL.
Can you help.
Thanks.