Re: how to insert characters in existing field

From: Steve Kass (skass_at_drew.edu)
Date: 12/08/04 

Date: Tue, 07 Dec 2004 23:54:28 -0500

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?
>
>