I haven't actually tried this...but you could create a new dictionary; e.g. 1> S 2> 0 3> Status*Date 8> A;2:"*":3 9> L 10> 10 Then select where new dict = "A*]" and "B*"
Mark -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Noah Hart Sent: Tuesday, February 17, 2009 11:27 AM To: [email protected] Subject: [U2] Need help with SELECT limiting MV I have a table with a MV status code and date field. I am trying to select just those records that have both status code A and B and when the date associated with code B is blank ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
