> From the solution you suggested, i seem to have
> to do it record by record.

"Freger" <anonymous@discussions.microsoft.com> wrote in message
news:04c601c39c60$ac3a9620$a601280a@phx.gbl...
> Hi Srinivas,
>
> It doesn't work because it is many the whole column i want
> to trim. From the solution you suggested, i seem to have
> to do it record by record.
>
> Any other suggestions?
>
> Freger
> >-----Original Message-----
> >Does this work?
> >
> >UPDATE MyTable
> >SET MyColumn = REPLACE(MyColumn,' ','')
> >
> >Srinivas Sampangi
> >
> >"freger" <freger79@hotmail.com> wrote in message
> >news:03e601c39c4a$13745590$a501280a@phx.gbl...
> >> Hi,
> >>
> >> I have a column in an SQL table which i would like to
> trim
> >> the spaces between string.
> >>
> >> e.g EV 21 to EV21
> >>
> >> Can anyone tell me how to do it manually. I know i can
> do
> >> it automatically in DTS. But I would like to do an one-
> off
> >> from the query analyzer. Can someone tell me.
> >>
> >> Thank you.
> >>
> >> Freger
> >
> >
> >.
> >

>-----Original Message-----
>> From the solution you suggested, i seem to have
>> to do it record by record.
>
>
>No, what lead you to believe that. The solution Srinivas
posted will modify all rows in the table
>(as it doesn't have a WHERE clause).
>
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>
>"Freger" <anonymous@discussions.microsoft.com> wrote in
message
>news:04c601c39c60$ac3a9620$a601280a@phx.gbl...
>> Hi Srinivas,
>>
>> It doesn't work because it is many the whole column i
want
>> to trim. From the solution you suggested, i seem to have
>> to do it record by record.
>>
>> Any other suggestions?
>>
>> Freger
>> >-----Original Message-----
>> >Does this work?
>> >
>> >UPDATE MyTable
>> >SET MyColumn = REPLACE(MyColumn,' ','')
>> >
>> >Srinivas Sampangi
>> >
>> >"freger" <freger79@hotmail.com> wrote in message
>> >news:03e601c39c4a$13745590$a501280a@phx.gbl...
>> >> Hi,
>> >>
>> >> I have a column in an SQL table which i would like to
>> trim
>> >> the spaces between string.
>> >>
>> >> e.g EV 21 to EV21
>> >>
>> >> Can anyone tell me how to do it manually. I know i
can
>> do
>> >> it automatically in DTS. But I would like to do an
one-
>> off
>> >> from the query analyzer. Can someone tell me.
>> >>
>> >> Thank you.
>> >>
>> >> Freger
>> >
>> >
>> >.
>> >
>
>
>.