how Create sql like Query with dynamic

[muthulk2]

ALTER PROCEDURE [dbo].[SelectResultAllDatails]

AS
BEGIN
		
DECLARE @query nvarchar(max), @VALUE NVARCHAR(10)

SET @VALUE = 'D013'

SET @QUERY = 'select * from dbo.ResultsDetails where [Student Index] LIKE ''' + @VALUE + '%''' 

SELECT @query

END
GO

[Rabbit]

Please use code tags when posting code or formatted data.

Use an input parameter. You can read more about creating procedures from microsoft's documentation: http://msdn.microsoft.com/en-us/library/ms187926.aspx. You also shouldn't build a SQL string that way, it's subject to SQL injection attacks.