Doesn't "tonumber" return a numeric value instead of a string?
Chad Petrovay | Collections Database Administrator
MIM-Musical Instrument Museum | 4725 E. Mayo Boulevard | Phoenix, AZ 85050
480.478.6000 main | 480.478.6058 direct | 480.471.8690 fax | www.themim.org
Blog: www.petrovay.com/tmsblog
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Stephanie Hansen
Sent: Friday, August 06, 2010 3:38 PM
To: [log in to unmask]
Subject: tonumber trouble
Hello,
Hoping one of you crystal gurus out there knows what I'm doing wrong. I keep
getting the error "a string is required here" when I try to turn the string
casenumber into a number so it will sort correctly.
SELECT{?group}
CASE 'LENDER' :{Constituents.AlphaSort}
CASE 'SECTION':{ExhObjXRefs.Section}
CASE'CHECK#': tonumber({ExhObjXRefs.CaseNumber});
Thanks in advance for any help!
Stephanie Hansen
Milwaukee Art Museum