Tables: part and system, that are related.
A string column - data - exists in table system. Made of numbers separated by a hyphen.
The user provides a number value. If the number is found in this column data,
I want to select the row in table part.
This is similar to the "LIKE %value% in T-SQL.
After the "select a where _", the object b is not recognized in intellisense.
What is the code to explain criteria like this?
I have Visual Basic 2010 Express
Dim x = From a In dc.parts Join b In dc.systems On a.htsn Equals b.tsn _
Select a where _