Is there a way to mimic this SQL in Linq to LLBL?

select * from CUSTOMERS where CUSTOMERNAME like 'FRED_'

var q = from c in metaData.Customer
where c.CustomerName.Contains("FRED_")
select c;

But this returns "xxxFREDa" in the list as well. I need to get only FREDa, FREDb, FREDc. One character on the end basically and starts with "FRED".

In Linq to SQL I'd use the SqlMethods.Like() helper function.

Is there something like that in Linq to LLBL?

String: Contains, String.StartsWith and String.EndsWith

var q = from c in metaData.Customer
where c.CustomerName.StartsWith("FRED")
select c;