I am having trouble with one of my stored procedures that is supposed to grab all of the OGC's from within one of my tables. All of the OGC ID's are between 10000 and 29999. I have tried using the between clause and I have also tried just saying select all from that table, but they have both not worked. Here is the snippet of the code that I am having trouble with:

Else If @UserType='CSR' OR @UserType = 'ADMIN'
/* Grab all of the OGC's*/
select distinct * from OGC
WHERE OGC.OGCID = 1
order by businessname,lastname,firstname


Thanks