Does SQL Server have anything like VFP's IIF where I can check if the user leaves the judgecode blank and I would add the following in VFP
"where IIF(!EMPTY(parameter),judgecode=parameter,!empty(judgecode))"

Thanks Again !