hi their

EMP_ID Attend ID
E0001 AT0001
E0002 NULL
E0003 AT0005
E0004 NULL

This is the normal out put i got
just what i want to do is if there any NULL on the Attend id its display as NOT ATTEND
This is what i need get

EMP_ID Attend ID
E0001 AT0001
E0002 NOT ATTEND
E0003 AT0005
E0004 NOT ATTEND

Any IdeaGive a look to either COALESCE or ISNULL in books online. Change where you are selecting "Attend ID
" to ISNULL( [Attend ID], 'NOT ATTEND') or COALESCE( [Attend ID], 'NOT ATTEND')