Hi

I am getting the error as

declare @pi_input varchar(max)

declare @query varchar(max)

select @pi_input ='0123456'

SET @query = N'Select '+'SUBSTRING(@Input,'+convert(varchar,0) +',1)'

print @query

exec (@query)

Select SUBSTRING(@Input,0,1)

Msg 137, Level 15, State 2, Line 1

Must declare the scalar variable "@Input".

how to resolve it

thanks!