Adding Columns With Same Value : I need help in deleting rows from by table with an Update statement were there are characters other than the numbers. I need to remove "words go here" and "hello how are you". Please see below

    999999   45.72
    999999   55.36
    words go here
    999999   411.12
    Hello how are you
    8888888   63.39 
  
