Remove letters in column

I have a column that have numbers & letters combined in a field. What sql
command would remove the letters only, not the numbers?
I have a table called “customer” and the column in that table is called
“customtext4”. I want to change over 5000 records in this “customtext4” field

Thanks for your help
Dave
.

Relevant Pages

  • Re: redraw a listbox
    ... but it will need to be attached to an event - maybe a command button or at ... the end of the event that is changing the SQL? ... > changed the SQL in the row source? ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • kde-pim
    ... of command line stuff like "./kdepim" and so forth on every executable I ... TIA ... Dave ... Prev by Date: ...
    (comp.windows.x.kde)
  • Re: easy photo to web thing
    ... > Thanks, Dave. ... Um, OK, it's just a script at the command line from the user ... Prev by Date: ...
    (comp.sys.mac.apps)
  • Re: Transfer data from one table to another
    ... Thanks Wayne. ... must do a bit more SQL ... Cheers Dave ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: response.redirect
    ... Yes, sir, I like that! ... Dave ... >> I can send a user back one page with this command: ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)