SELECT types, comp_name, modal, to_char(manufact_dt,'dd/MON/yyyy'), to_char(purchase_dt,'dd/MON/yyyy'), dealer_nm, cc, avg, to_char(rto_passing_dt,'dd/MON/yyyy'), veh_no, color, appro_val, extra_info, to_char(dt,'dd/MON/yyyy'), necessary_info, name, email_id, village, place, taluka, ph_no, extra FROM vehicle where 1=1 and wheel='Y|L jCL,Z' and flag='n' question : Here in my database wheel column have the same value but then even why I am not getting any row as output for this query. Pls George help me Regards, Rinku