Well, this should do it i quess.
not 100% sure about the and statement though.

Code:

Use DB_name

SELECT Command, GroupName

FROM Groups

WHERE Command = 'BackFolder' and GroupName = 'Medical Records'


Can't test right now, cause I don't got sql on my laptop.

Edited by R2D2 (2003-12-15 10:32 PM)
_________________________
Mart

- Chuck Norris once sold ebay to ebay on ebay.