Thanks for the info. It is going to take a while to wade through this.

All the fields are interger numbers.

I would have never figured out this solution.

You people are great.

I tried:

where

         convert(varchar,BATCH_DATE)

+ '.' + convert(varchar,batch_nmbr)

+ '.' + convert(varchar,BATCH_CTR) =

'20050404.09000.0001'

I got an sqlcode of 100

When I changed the "=" to ">=" it returned that particular row???