>>>>*** 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>>