Case funtion

[danarashad]

select fname,lname,ID,
(select sum(cast(pointsappr as INTEGER)) from proff p where D.ID=P.userid and p.show_name='1. College Course Graduate Level') as total
from Demographics d
order by ID
I am getting an error, when i run this, what am i doing wrong. if i take out the (cast as integer) it works, but i need to cast this as a number.

 

[GUJUm0deL]

This really belongs in forum183.

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[philhege]

Try (CAST pointsappr AS INT).

Also, where is the table that's aliased as "P"? I don't see it in your query.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Pity the amnesiac dyslexic agnostic. He stays up all night, wondering if there really is a dog.