Greetings all, I'm wanting to show a list of options with the option named 'Other' always appearing at the bottom, otherwise everything appearing in alphabetical order. My query looks like this:
SELECT how_id, how_name FROM howHearTypes ORDER BY iif(how_name = 'Other','ZZZZZZZZ',how_name) And is returning an error: "Line 3: Incorrect syntax near '='." Does anyone know what's wrong with my syntax? This is on MS-SQL Server 2000 btw. bye! ----------------------- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
