Click here to Skip to main content
13,044,428 members (113,877 online)
Click here to Skip to main content

Tagged as


Posted 14 Nov 2012

how to search record with last digits of ID number

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



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


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


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 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.

You may also be interested in...

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