'BETWEEN' documentation pointer?

Can anyone point me to any online documentation on how to use the
'BETWEEN' operator/function?  (As in "SELECT * FROM foo WHERE id BETWEEN
...")

Regards,
Ed Loehr