dwain

fantastic that seems to work fine, will that also cover any null values

much appreciated

alan

my next post is going to be on a bulk insert I am having a problem with for inserting the rows into the database for this query, am i allowed to post in here or would i have to set another post up