Thanks for your help, I put a to_char() around the vm.bodytypecd and this seems to work.

Just having a blond moment (no offence meant - I am blond...)

Allie