Make sure that it is numeric values

[#1]

Hi

I have a simple question, but I need a simple command.

I have 2 different databases, and I have a field in both tables that are "Orders". The problem is that I'm not sure that they are both numeric.

What do I have to put in front of the field name to be sure ex: XXXX(Orders)?

I'm not even sure that it is the correct approach to the problem - can anybody help?

Best regards

Annette

[swuehl]

num(Orders) should do what you want, it will format the number representation of your Orders field and return NULL if no number representation exists.

[#3]

Hi Swuehl

Thanks for your quick reply.

It was helpful...

Best regards

Annette