retrieve from SQL Server Using ASP

currently, i created a page for user to select a alphabet (A-Z), then i want to get all the members name which start with the key-in aplhabet
i'd tried using SQL command to retrieve it,but nothing came out
tempalpha = request.form("alpha")
sSQL = "Select * From IMAGE1 where emp_id like '"
sSQL = sSQL & tempalpha% & "'"
is that correct...after it couldn't worked i try this
i changed tempalpha% to tempalpha_...
but the same result came out,
pls help me