Hi

We have a field in many tables named "ReportID"

here are some samples:
2007001xx2z55
2007002xx1z22

2007001 is Julian date then adds user id information after that. This field is indexed in the database. Although if a query has between 2007001 and 2007002 it wont work. Is there a way to use Julian date in this index field? Somehow isolate first 7 characters and to run data range queries on it?

Thanks!

You can easily isolate the Julian Date portion of the data with a DEFINE, but since I assume this is an indexed column in a DBMS table, the DEFINE will not be passed to SQL.

Have you tried:

WHERE ReportID GE '2007001' AND ReportID LT '2007002'

I think this should work, non?

Thanks! That worked great!