MSQL Help - Returning Value

[Gunner54]

$query = mssql_query("UPDATE Character SET Sex = '$Sex' WHERE Name = '$Char'"
$CID = mssql_query("SELECT CID FROM Character WHERE Name = '$Char'");
$query = mssql_query("DELETE FROM CharacterItem WHERE CID = '$CID'" 

Obviously i thought $CID would = the value selected. But Obviously it doesnt. How can i make $CID = the SELECT CID FROM Character WHERE Name = '$Char' Value?

Thank You