Great... it is working fine.

thanks for all.

Kingston Dhasian (6/14/2013)

---

Change the final SELECT statement to something like this

SELECT*, CAST( ( game1 + game2 + game3 + game4 + game5 ) / 5.0 AS NUMERIC(10,1) ) AS [percent]

FROMcte_Students

Thanks...

ChrisM@Work (6/13/2013)

---

-- sample data

;WITH students (ID_Student, Name, rate) AS (

SELECT 1, CAST('Chipper Jones' AS nchar(30)), CAST('678*9' AS nchar(5)) UNION ALL

SELECT 2, 'Mike Piazaa', '98***' UNION ALL

SELECT 3, 'Barry Bonds', '678**'...

Kingston Dhasian (6/13/2013)

---

It happened because the data types for columns game1, game2,...game5 were taken as VARCHAR

The below code will avoid the issue

; WITH cte_Students AS

(

SELECT*,

CASE WHEN SUBSTRING(rate, 1, 1) =...

Kingston Dhasian (6/12/2013)

---

You can use a CTE or a Derived table like this

; WITH cte_Students AS

(

SELECT*,

CASE WHEN SUBSTRING(rate, 1, 1) = '*' THEN '10' ELSE SUBSTRING(rate, 1, 1) END AS...

Pelon (6/4/2013)

---

Kingston Dhasian (6/4/2013)

---

Something like this..

SELECT*,

CASE WHEN SUBSTRING(rate, 1, 1) = '*' THEN '10' ELSE SUBSTRING(rate, 1, 1) END AS game1,

CASE WHEN SUBSTRING(rate, 2, 1) = '*' THEN '10' ELSE...

Thanks for your help.

Now I have a doubt, I would like to add the numbers of each column and after add them i want divide them to get ...

Kingston Dhasian (6/4/2013)

---

Something like this..

SELECT*,

CASE WHEN SUBSTRING(rate, 1, 1) = '*' THEN '10' ELSE SUBSTRING(rate, 1, 1) END AS game1,

CASE WHEN SUBSTRING(rate, 2, 1) = '*' THEN '10' ELSE SUBSTRING(rate,...

Yes, it works !

Thank...

Thanks, everyone.