A ver, prueba asi aver si va:
Código PHP:
while($row=mssql_fetch_array($result)){
$CharID = $row['CharID'];
$consulta2="SELECT sItemID FROM ITEM_T WHERE CharID = '$CharID' AND sItemID BETWEEN 403 AND 428";
$result2=mssql_query($consulta2);
Espero que si te vaya.
Saludos.