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
Default

thanks for your response.

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

SELECT employees.name, 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
 END,
employees.posit


Regards

Mateen




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