|
-
August 27th, 2011, 10:40 PM
#1
sql computed column formula syntax help
i got two columns in mysql 2005
Grade and Remarks
i need to do is.. when i input integers in grade column
1,1.25,1.50,1.75,2,2.25,2.50,2.75,3
then Remarks will show PASSED
and when Grade is 4 up
remarks will show FAILED
(OPTIONAL)
if Grade is null
then Remarks will show UNKOWN
this is my code but it doesnt works on sql computed column formula
IIF(Grade >=4, 'Failed', IIF(Grade IN (1,1.25,1.50,1.75,2,2.25,2.50,2.75,3), 'PASSED','UNKNOWN'))
can anyone revise my code into.. sql formula code?? thanks
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|