Thread: SQL Assistance
View Single Post
  #5 (permalink)  
Old 02-05-08, 04:07 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
Try WRITETEXT instead of UPDATE, something like this. I'm guessing on the exact syntax here cos I don't have a SQL2000 database to play with.

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