SELECT * FROM MyTable WHERE Title like 'PR%'
SELECT * FROM MyTable WHERE Title like @PR + '%'
DECLARE @sqlQuery nVARCHAR(500) SET @sqlQuery = 'SELECT * FROM #tempSectionDetails WHERE Title like '''+@Title+ '%' + '''ORDER BY Title' EXECUTE sp_executesql @sqlQuery
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)