Thread: SQL Assistance
View Single Post
  #8 (permalink)  
Old 02-05-08, 04:14 PM
Lazlo's Avatar
Lazlo Lazlo is offline
Not a number
  
Tournaments Won: 1

Join Date: Jul 2005
Location: York
Posts: 2,376
Lazlo communes with fishLazlo communes with fishLazlo communes with fishLazlo communes with fishLazlo communes with fishLazlo communes with fishLazlo communes with fishLazlo communes with fishLazlo communes with fishLazlo communes with fishLazlo communes with fish
Update to the above. Looks like you need a TEXTPTR as part of the syntax. So the above gets changed to:

DECLARE @ptrval varbinary(16)

SELECT @ptrval = TEXTPTR(MIGRATION_COMMUNICATION.COMM_NOTE)

WRITETEXT MIGRATION_COMMUNICATION.COMM_NOTE @ptrval
(SELECT RTRIM(DOCDESC) + ' '+'-'+' ' + RTRIM(MEMO) FROM MIGRATION_COMMUNICATION)
__________________
Ian
Reply With Quote