Thank you. It works Chuck Conrad -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lucas Edwards Sent: Monday, 13 September, 2004 11:55 To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Compute Problem
Conrad, if you're using COMPUTE then the syntax would be: compute ved as max edulevel from appeduc where appno = 129 But you should probably use SELECT instead: select max(edulevel) into ved indicator vi from appeduc where appno = 129 Regards Lucas [EMAIL PROTECTED] wrote: > I have used the following command > > compute ved as max(edulevel) from appeduc where appno = 129 > > and I receive error 150 that compute can not be done on this data type. > > The data type is text 2. > > I have check the help for compute and there is no restriction on text > for using max > > Any suggestions? > > Conrad > > > > >
