>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
>
>select Min(CVDate(IIf(([a] & " " & [b])="",Null,[a] & " " & [b]))) AS ARRIVAL
My first guess: (It's actually one whole line)
select min(convert(datetime, convert(varchar(8), isnull(@a, '19000101'), 112) + isnull(@b, ' 00:00:00'))) as arrival
-Mike