how to insert characters in existing field

From: Tiffany (Tiffany_at_discussions.microsoft.com)
Date: 12/08/04

  • Next message: Steve Kass: "Re: how to insert characters in existing field" 
    Date: Tue, 7 Dec 2004 18:55:04 -0800

    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?

  • Next message: Steve Kass: "Re: how to insert characters in existing field"

    Relevant Pages

    • Re: Connection.Execute causes untrappable runtime error
      ... Set Recordset = Database.Execute ... If I want to do a delete or Update, I do a Database.Execute ("SQL Syntax") ... I believe that the dataenvironment is the best thing in vb6 (The program are ...
      (microsoft.public.vb.database.ado)
    • Re: SQL Generator library
      ... I'm not sure what you mean by an object graph. ... syntax to three statements that seem to have ... SchemeQL[2] for Scheme that have similar goals. ... I think that the SQL it uses should be fairly portable, ...
      (comp.lang.ruby)
    • Re: Difference in Left Join, Right Join
      ... RIGHT syntax exist. ... If you write SQL such that what you feel is the driving table is at ... The above is Oracle outer join syntax, ...
      (comp.databases.oracle.misc)
    • RE: EXISTS reserved word in FROM clause
      ... we make a good pair because I know Access SQL ... from what you described the query syntax that I ... >The subquery should return the records: ...
      (microsoft.public.access.queries)
    • Re: Control Source Blues
      ... be careful of the difference in syntax between talking to mdb or SQL ... this kind of project is most of my control sources are stored procedures ... >I am converting an Access database to an Access Project. ...
      (microsoft.public.access.forms)