Mensaje
De
16/03/2010 18:30:54
a
16/03/2010 07:43:34
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
ID de la conversación:
01454718
ID del mensaje:
01454976
Views:
27
Yep, dropped back to VFP, glad it worked.
>Hi Neil, I take it you meant char(10) not chr(10) ? Anyway what I did was this
>
>
>thanks for pointing me in the right direction - it worked a treat.
>Hi Neil, I take it you meant char(10) not chr(10) ? Anyway what I did was this
>
>
>update mytable >set myfield = replace(replace(myfield,char(10),''),char(13),'') >>
>thanks for pointing me in the right direction - it worked a treat.
Regards N Mc Donald