Thanks JBelthoff for the reply, I follow ur example but its still not working , the code are as follow, IF (@MASTER = 'NRICSEARCH') BEGIN SELECT CASE WHEN ACTIVE= 1 THEN 'ACTIVE' ELSE 'INACTIVE' END AS ACTIVE, USER_ID, NRIC + '--' + NAME+ '(' + CONVERT(VARCHAR, ACTIVE) + ')' AS NRICNAME FROM M_USER ORDER BY NRIC -- Column ACTIVE is of type bit. NRICNAME is used in the listbox as datatextfield The Current Output from the current code in the listbox is as follow, 123--Ben(0) 124--Andy(1) The Desired Output in the listbox is as follow, 123--Ben(ACTIVE) 124--Andy(INACTIVE) Apparantly, The CASE is not working.