CREATE TABLE ...
.... othercolumns,
Grade ....,
Remarks AS CASE WHEN Grade IS NULL THEN 'UNKNOWN'
                WHEN Grade <4 THEN 'PASSED'
                ELSE 'FAILED'
           END
)

drop table student

create table student
(
P_Key int IDENTITY,
Student_Number varchar(50) NULL,
Grade decimal(10) NULL,
PRIMARY KEY (P_Key),
Remarks AS CASE WHEN Grade IS NULL THEN 'UNKNOWN'
WHEN Grade <4 THEN 'PASSED'
ELSE 'FAILED'
END
)


insert into student (Student_Number,Grade)
select 'abnm',1 union all
select 'fdw',null union all
select 'aFS',2 union all
select 'zxvc',7 union all
select 'zV',5 union all
select 'abnzvxzxvm',3 

select * from student

output
------------------------------------
P_Key       Student_Number                                     Grade                                   Remarks
----------- ----------------------------- ----------------- -------
1           abnm                                               1                                       PASSED
2           fdw                                                NULL                                    UNKNOWN
3           aFS                                                2                                       PASSED
4           zxvc                                               7                                       FAILED
5           zV                                                 5                                       FAILED
6           abnzvxzxvm                                         3                                       PASSED

quote:

---

Originally posted by raokikun

grade is decimal sir.
because. ahm our system must read 1, 1.25, 1.50, 1.75 etc. its for our school
then make sure you give a scale value too ie like decimal(10,2) else it will default to 0 and you cant store decimal
sir may i ask a question..
what is the purpose of union all?
union all is used for merging resultset from different queries see example usage in MSDN or books online
have you tried it in vb.net? and is it working?
i must not add records or grades using sql

NOTE:
i must add records using vb.net in a datagrid view

ill give it a try again, hope this works for now
im running out of time for our thesis..im the only one making in our group because my groupmates doesnt know anything about coding..
then it might be problem in calling query from VB app. I'm not an expert on VB so you can post it in VB forum to get more help
THANK THANK YOU VERY MUCH! ill give it a try now asap :)

---