MI-L Getting the results of SQL query into a variable

[Mick]

Hi, is there any way to get the results of an SQL query into a variable. What I want 
is the result of a SUM query and use that result in other parts of my program. Is this 
possible?

Thanks
Mick