Home Forums Programming General String Tokening RE: String Tokening

  • March 14, 2005 at 7:24 am

    #546811

    Not aware of a function, per se but you could try this

    SELECT CASE WHEN PATINDEX('%[^0-9]%',[Input])>0

    THEN LEFT([Input],PATINDEX('%[^0-9]%',[Input])-1)

    ELSE [Input]

    END

     

    Far away is close at hand in the images of elsewhere.
    Anon.