sql statement

A sql table with three fields tbl_loc char(2) tbl_id int with max 5 digi tbl_name char(20) I want to a select statement as partid=tbl_loc+tbl_id,tbl_name from table if tbl_loc='AA' and tbl_id=1, or tbl_loc='AA' and tbl_id=18, I want the output is AA-00001,name1 AA-00018,name2 .... ****** tbl_loc is char and tbl_id is int ****** ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Platform sql7 or sql2000