Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Select a matching rows which exist in particular string RE: Select a matching rows which exist in particular string
Phil Parkin
SSC Guru
Points: 247210
More actions
April 14, 2015 at 6:06 am
#1790758
Actually, this version should be faster:
select * from @SAMPLE_DATA sd
where @strname like sd.SD_TEXT + '%'