finding record from table [Resolved]

Posted by Shoyebaziz123 under Sql Server on 5/10/2012 | Points: 10 | Views : 1859 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	Use Like Keyword for your Solution Ajay ajaypatelfromsanthal.blogspot.in Shoyebaziz123, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts