-
WHERE clause in select statement
I have a 6 digits ID number. Take ABCDEF as an example (each letter representing a digit)
I need to select those numbers whose BC is equivalent to a 2 digit number like "16" and its DEF is greater than a 3 digit number like "017"...
please take note that only the 3 last digits are compared not the entire number.
how I can write these conditions under the WHERE clause of the statement to achieve what I explained above?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|