Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
DECLARE @GrantNumber varchar(2000) set @GrantNumber = '%01NS061975%|%03NS065487%|%37NS024247%|' SELECT GrantNumber from TableA WHERE GRANTNUMBER IN ('%01NS061975%','%03NS065487%','%03NS065487%') I need to split the @GrantNumber delimited by | and use the 'IN' condition with 'LIKE' Also it should use the wild card card character. Basically condition where i need to use the wild card with LIKE
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!