Search Text and numer in One Query

Posted by NARAAYANAN under Sql Server on 6/21/2013 | Points: 10 | Views : 1486 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi All.
How can we search Text and Number in One Query?
In my Table , I have two column one is Customer id and Customer name . Customer Id is Integer field and Customer name is Varchar field. So How can we search text and number in one Query?

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Niladri.Biswas on: 6/23/2013 [Member] Platinum | Points: 25

0	... where [Customer Id ] = @CustId And [Customer name ] = @CustName Best Regards, Niladri Biswas NARAAYANAN, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Kirthiga on: 6/24/2013 [Member] Starter | Points: 25

0	Hi Naraayanan, By using logical operators in where clause we can search two different values select * from TableName where [Customer id]=123 or [Customer name ] ='abc' NARAAYANAN, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts