finding record from table [Resolved]

Posted by Shoyebaziz123 under Sql Server on 5/10/2012 | Points: 10 | Views : 891 | Status : [Member] | Replies : 2
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 ?




Responses

Posted by: Shoyebaziz123 on: 5/10/2012 [Member] Starter | Points: 25

Up
0
Down

Resolved
Ok , thanks i have solved that problem.

Shoyebaziz123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ajay.Kalol on: 6/4/2012 [Member] Starter | Points: 25

Up
0
Down
Use Like Keyword for your Solution

Ajay
ajaypatelfromsanthal.blogspot.in

Shoyebaziz123, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response