Try; SELECT max(zinr) as maxZinr FROM zimmer WHERE mpehotel=1
The zinr column is an int right? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
