Update problem

Discussion in 'ASP General' started by Poppy, Mar 4, 2004.

  1. Poppy

    Poppy Guest

    Performing an update in asp is pretty straightforward but I am not sure how
    to do the following and would appreciate a bit of help.

    I need to update a field "fld1" by replacing the left 3 characters of "fld1"
    with something.

    Any ideas ?
     
    Poppy, Mar 4, 2004
    #1
    1. Advertising

  2. Poppy

    Ray at Guest

    What kind of database?

    UPDATE theTable SET fld1='something'+right(fld1,len(fld1)-3)

    Ray at work

    "Poppy" <> wrote in message
    news:...
    > Performing an update in asp is pretty straightforward but I am not sure

    how
    > to do the following and would appreciate a bit of help.
    >
    > I need to update a field "fld1" by replacing the left 3 characters of

    "fld1"
    > with something.
    >
    > Any ideas ?
    >
    >
    >
     
    Ray at, Mar 4, 2004
    #2
    1. Advertising

  3. Poppy

    Poppy Guest

    Thanks Ray.

    Its an access database.

    "Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
    message news:...
    > What kind of database?
    >
    > UPDATE theTable SET fld1='something'+right(fld1,len(fld1)-3)
    >
    > Ray at work
    >
    > "Poppy" <> wrote in message
    > news:...
    > > Performing an update in asp is pretty straightforward but I am not sure

    > how
    > > to do the following and would appreciate a bit of help.
    > >
    > > I need to update a field "fld1" by replacing the left 3 characters of

    > "fld1"
    > > with something.
    > >
    > > Any ideas ?
    > >
    > >
    > >

    >
    >
     
    Poppy, Mar 4, 2004
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Hartmut Schroth
    Replies:
    3
    Views:
    3,543
    Hartmut Schroth
    Dec 1, 2003
  2. joun
    Replies:
    9
    Views:
    2,280
    W.G. Ryan eMVP
    Nov 30, 2004
  3. joun
    Replies:
    5
    Views:
    2,706
  4. =?Utf-8?B?TWljaGFlbA==?=

    How to update datagrid after update

    =?Utf-8?B?TWljaGFlbA==?=, Mar 17, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    522
    Alex D.
    Mar 17, 2006
  5. Stephan Kämper
    Replies:
    1
    Views:
    167
    Assaph Mehr
    Jul 15, 2006
Loading...

Share This Page