>>>>

>>>>*** SelectCmd
>>>>SELECT ISNULL(YourTable.OptionID,?m.selOptionID) AS OptionID,
>>>>       ISNULL(YourTable.MakeId  ,?m.selMakeID)  AS lMakeID,
>>>>       ISNULL(YourTable.ModelId  ,Models.Id)    AS ModelId,
>>>>            rest of the fields
>>>>FROM YourTable
>>>>FULL JOIN Models ON YourTable.ModelId = Models.Id AND CHARINDEX([_]+CAST(Models.Id as varchar(20))+[_] , ?m.lcModels) > 0
>>>>WHERE YourTable.OptionID = ?m.selOptionID AND
>>>>             YourTable.MakeId   = ?m.selMakeID   AND
>>>>            CHARINDEX([_]+CAST(YourTable.ModelId as varchar(20))+[_], ?m.lcModels) > 0
>>>>
>>>>m.selOptionID = 1
>>>>m.selMakeID  = 12
>>>>lcModels       = "_1_7_12_225_"
>>>>

>>>
>>>

>>>SELECT ISNULL(YourTable.OptionID,?m.selOptionID) AS OptionID,
>>>>       ISNULL(YourTable.MakeId  ,?m.selMakeID)  AS lMakeID,
>>>>       ISNULL(YourTable.ModelId  ,Models.Id)    AS ModelId,
>>>>            rest of the fields
>>>>FROM Models LEFT JOIN myTable on Models.ID = myTable.ID and myTable.MakeID = ?lnMakeID
>>> where cast(Models.ModelID as varchar(20)) $ ?lcModels

>>
>>
>>??????????
>>No. WHERE clause should be in WHERE not in JOIN
>>BTW isn't it SQL Server?
>>And not LEFT but FULL join.
>
>VFP table. And I think the last select I posted should do it.

Then why in your post DB is set to SQL Server? :-)))))))))))))))))
O!!!!!
I just saw that you reverse FROM and JOINed tables :-))))))))))))))

Two things:
Put OptionsId also in JOIN condition (I didn't see it)
Use [_1_12_] pattern because when you want ModelId 1 you will get ALL that have [1] in the number 1, 10,11..19,21 etc.