I've been handed this access query to convert to VFP sql passthru and I really don't like my answer to the convertion. I would like any others' ideas.

SQL V 6.5
field a = datetime-----Time portion is incorrect.
field b = char(5)------Has correct time for field a
multible records per
some a and/or b may be null

I did not design either the access query or the SQL data and I can't change the SQL file.

Here is the ACCESS Statement I'm converting. I've got one that works but It's a mile and ahalf long. I know that there has to be a better way.

select Min(CVDate(IIf(([a] & " " & [b])="",Null,[a] & " " & [b]))) AS ARRIVAL

Anyone?

Jeff