Re: how to insert characters in existing field

From: Bosse (Bosse_at_discussions.microsoft.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 07:09:06 -0800

Steve!

I have a similar problem where I want to replace the domain part in a column
with e-mail addresses. Like aaa@xxx.se with aaa@yyy.se. I tried using the
tip you gave Tiffany but nothing happens.
Any clues?

Regards,
Bosse

"Steve Kass" wrote:

> Tiffany,
>
> It sounds like what you want is
>
> update test2 set
> model = 'WM' + model
> where model = 'FX%'
>
> This will paste WM on the beginning of all the FX... model names.
>
> Steve Kass
> Drew University
>
> Tiffany wrote:
>
> >Hi,
> >
> >I have a sql table with a field name model. In the model column, i have
> >model number that start with FX%.
> >
> >I want to add WM before FX%. After FX can be anything, characters or
> >numbers. The model data type is varchar.
> >
> >How can i do it. I tried using the syntax below but not successful.
> >
> >update test2 set model = 'WM%' where model = 'FX%'
> >
> >Can anyone help?
> >
> >
>