How can I do a Select statement if, in the WHERE part, I compare with a variable taken from a web input?

Ex:

Select *
From Table1
Where Name= name ( this is the variable )

I read that we should put % like %name% to signifie that this is a variable, put it's not working when I do that...

Thanks!