Thanks much. I have another issue. I have some dates stored as varchar(50) in a work table which I need to first parse out the text data from...

Thanks, works now. I guess the trick was to enclose them in a sql statement.

will remember that. Does that work as well for date and time...

Thanks much. I tried it after tweaking it a bit. pulled the @d_code and @field_name out of the quotes and ran it. It still does the same...