Posted by JackpipE on 02/22/07 21:01

Here is my replace query and I need to run this on every column in my
table. Right now I manually enter the column name (_LANGUAGES_SPOKEN)
but this is time consuming and would like to automate this process as
much as possible.

Update PROFILE
SET LANGUAGES_SPOKEN = replace(cast(_LANGUAGES_SPOKEN as
nvarchar(255)),char(13)+char(10),':')

Thanks,
JP

• Next in forum: Re: How to run replace on all columns
• Prev in forum: Re: Format money value as padded string
• Thread view: How to run replace on all columns

[Reply to this message]