Re: Sql Count

[Jeffrey Bedell <Jkbedell@SYR.EDU>]

You forgot the SELECT statement.

Jeffrey K. Bedell
Senior Systems Analyst
Information Systems
Syracuse University
(315) 443-9273

>>> jrupp@TECHNEGLAS.COM 01/03/02 06:38PM >>>
Hello All:

I am trying to do a count - Select count(*) - in sqr and move the value
to a variable to be used later.  This is how I did it:

Begin-sql
count(*) &Count
FROM PS_JOB
End-Sql

What am I doing wrong?

Thanks for the help!!