View Single Post
  #5 (permalink)  
Old April 8th, 2004, 01:48 AM
mateenmohd mateenmohd is offline
Friend of Wrox
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts

thanks for your response.

Please give me one example of iif function.
how can use iif function in this query

SELECT, employees.posit
FROM employees
ORDER BY employees.posit;

I want to display the records like this.

order by
 CASE employees.posit
  WHEN 'Sr. Resident Engineer' THEN 1
  WHEN 'Resident Engineer' THEN 2
  WHEN 'Asst. Resident Engineer' THEN 3
  WHEN 'Quantity Suveyor' THEN 4
  WHEN 'Inspector (As Built)' THEN 5
  ELSE 6



quote:Originally posted by manuel
 You colul use only the iif(iif, , ) , , ) instruction
Reply With Quote