SQL Server :: Weighted Keyword Search?

I am searching for products out of my database:
AND (CONTAINS(P.name,
@contains_key)
OR
CONTAINS(P.description,
@contains_key)
OR P.sku
like
'%'
+ @Keywords
+
'%')

As you can see I'm using the CONTAINS statement and searching against the name and description fields.I would like to give the results a weight (or score) based on how often the word shows up and in what field.Example:if the word shows up in the name field -- give it 2 points every time the words appears.if the word shows up in the description field -- give it 1 point every appearance.Then ORDER the query based on the Score. And, perhaps add a where clause that the Score > 1 or some value.I realize, I will probably have to re-write my query and this "point" system may not be possible, but I know there is a way to weight results, but can't find any help online. I would also assume, this would be done in temp tables and select statements and directly in the where clause.