Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version

Tagged as

how to search record with last digits of ID number

, 14 Nov 2012 CPOL
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 =...

Revisions


  

Compare Revision Minor Date Status Editor
2 - publicly available No 14-Nov-12 16:55 Available Christian Graus
Updates in content. 82 changes had been made.
1 No 14-Nov-12 16:54 Available Christian Graus

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Christian Graus
Software Developer (Senior)
Australia Australia
Programming computers ( self taught ) since about 1984 when I bought my first Apple ][. Was working on a GUI library to interface Win32 to Python, and writing graphics filters in my spare time, and then building n-tiered apps using asp, atl and asp.net in my job at Dytech. After 4 years there, I've started working from home, at first for Code Project and now for a vet telemedicine company. I owned part of a company that sells client education software in the vet market, but we sold that and I worked for the owners for five years before leaving to get away from the travel, and spend more time with my family. I now work for a company here in Hobart, doing all sorts of Microsoft based stuff in C++ and C#, with a lot of T-SQL in the mix.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.141223.1 | Last Updated 14 Nov 2012
Article Copyright 2012 by Christian Graus
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid