thanks for the help, the isnumeric function

works fine.

cheers

Randy

WHAT I WANT TO DO IS MOVE THE INFORMATION IN

PULLER,

VERIFIER,

DATA_ENTRY

STOCKER,

INTO THE WORK_TYPE TABLE WITH ONE QUERY

Thanks for the reply, this has to be one of the best boards I've seen.

Here is the problem. I have a payments table

that holds all the payment information for each...