SQL code problem?

I have been following a tutorial off the net building ASP pages, which when changed to my scenario gives me some SQL of

SELECT fault_id
FROM faults
WHERE fault_id Like'%r_fault%'

(r_fault being a variable holding the param i want to find)

Am i right in thinking that if 1 is entered LIKE will find all records with a 1 (1,21,12,41 etc)
So the question - whats the alternative to LIKE which will find the specified record only?
Thanx

SELECT fault_id
FROM faults
WHERE fault_id = 'r_fault'

S-