Thanks Daniel. I'll give it a try. The other one works by the way but if you say it's more effient then I give this one a try.
I know there are more field types that what I am checking for but with the type of data that we have and the structure that I set up on the sql server, we will never use ie general.....field types....we don't deal with pics or bmps so we will not use that..i have c, m, n, l, d, t.....
Thanks in Advance.
J. Turner