I\'m writing sql query to my SqlCommand, and some part of them looks like: WHERE Path like N\'+(select top 1 path from[Paths] where objectcode=@objectCode and objecttype=@objectType)+%\' order by pat