Home Forums Article Discussions Article Discussions by Author Discuss content posted by Atif Sheikh Way to Check Multiple LIKE without dynamic SQL RE: Way to Check Multiple LIKE without dynamic SQL
bhatta
SSC Rookie
Points: 25
More actions
September 16, 2010 at 2:40 am
#1221992
if you use function !!! write new fn_split_find and don't use cross apply .it's will be work more faste :-D)
select * from @mytbl where fn_split_find(likestring,@param) >0