>IF there is not a matching value in the table, use '00000' >
SELECT ISNULL(FieldName, '00000') AS MyFieldName (removed rest of SQL)