finding record from table

Hi,

i have a problem with sql query how to find matching record from table having acolumn with record like this

BIll Number
ALPL/2012-2013/WR/1
ALPL/2012-2013/BN/1
ALPL/2012-2013/BN/2
ALPL/2012-2013/WR/2
ALPL/2012-2013/BN/3
ALPL/2012-2013/BN/4
ALPL/2012-2013/BN/5
ALPL/2012-2013/FD/1
ALPL/2012-2013/WR/3

now i am passing the value WR or BN for eg. so only record with WR or BN must be shown ,
for eg. i am sending WR then rows of ALPL/2012-2013/WR/1 , ALPL/2012-2013/WR/2 , ALPL/2012-2013/WR/3 must be the output.

How can i do this ?

[Resolved]