If you back it up using disk or tape via arcserver/backupexec, the software will compress the backup file onto the selected storage device for you. If you need to copy it between servers then you...
If NULL is a legitimate value ie. (NO VALUE), 0, 1, 2 you can use the COALESCE function to get the result your looking for. ie. the following example return's...