I was wondering if someone could help me with at query.
I have 2 fields dwg_rev and dwg_rev_seq.
dwg_rev is at single letter and dwg_rev_seq is a number or NULL.
Can someone tell me how i could go about selecting the max letter and the corresponding max number?
Thanks,
Scott
I have 2 fields dwg_rev and dwg_rev_seq.
dwg_rev is at single letter and dwg_rev_seq is a number or NULL.
Can someone tell me how i could go about selecting the max letter and the corresponding max number?
Thanks,
Scott