Home Forums Programming General String Tokening RE: String Tokening
David Burrows
SSC Guru
Points: 65138
More actions
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.