how to search record with last digits of ID number

ryan is right, if it's a string, you can use a LIKE clause. If it's a digit, you will have to write SQL that turns it in to a string so you can use a LIKE clause ( assuming that works ). Otherwise, you're stuck. One possibility, if you were searching for 351, you could do where x % 1000 = 351. That would be if you divide x by 1000, 351 is the remainder. so if you were searching for a two digit number, it would be % 100, etc.
 
Having looked again, you're clearly storing a string, so searching x LIKE '%100' is what you need.

in my process i am using sql server 2008 r2 and 41/3/ is fixed and the value 100 will increment and only from 100 will save in database
like
100
101
102
103 so on
 
but for the barcode it will get
41/3/100
41/3/101
41/3/102
so onn...
 

when they scan with barcode scanner 41/3/102 or some thing in text box when they click search button how should i search with only 102 ???/

Hi,
 
Use the below code snippet into your search method.
 
string keyword = textbox.Text.SubString(textbox.Text.IndexOf("41/3/"));
 
and use keyword in your where condition.
 
Hope this will help you.