1> select name,username,guarantor,date,active from customer where username='mrcpu' 2> go name username guarantor date active ---------------------------------------- ------------------------------ ----------- ---- ------ Jaye Mathisen mrcpu 0 Feb 05 1998 12:00AM Y (1 row affected)