LINQ - How to translate patindex and substring
===

Could someone help me translate this Transact-SQL statement to LINQ?


    select distinct SUBSTRING ( car# ,1 , PATINDEX ( '%[0123456789]%' , car# )-1 ) from dbo.Purchases


Thanks
