Click here to Skip to main content
15,902,893 members
Home / Discussions / Database
   

Database

 
QuestionModules in Access Pin
DQNOK18-Apr-07 10:24
professionalDQNOK18-Apr-07 10:24 
QuestionSimple ADO database connection Pin
kinsella_john18-Apr-07 7:44
kinsella_john18-Apr-07 7:44 
QuestionSQL Server's Linked Server capabilities Pin
radshaykho18-Apr-07 7:31
radshaykho18-Apr-07 7:31 
QuestionBulk Upload Error Pin
saltcode18-Apr-07 5:08
professionalsaltcode18-Apr-07 5:08 
Questionsql String seach based on other Column Pin
Vimalsoft(Pty) Ltd18-Apr-07 2:59
professionalVimalsoft(Pty) Ltd18-Apr-07 2:59 
AnswerRe: sql String seach based on other Column Pin
kubben18-Apr-07 3:07
kubben18-Apr-07 3:07 
GeneralRe: sql String seach based on other Column Pin
Vimalsoft(Pty) Ltd18-Apr-07 3:11
professionalVimalsoft(Pty) Ltd18-Apr-07 3:11 
GeneralRe: sql String seach based on other Column Pin
kubben18-Apr-07 3:14
kubben18-Apr-07 3:14 
I guess I don't understand then. All three of those things are in the where clause. First you limit the result set by Extension and Num_key, then you limit it by display between 00274 and 01189. I am pretty sure the query I gave does what you are asking. It is doesn't please try to explain what you want again.

Ben
GeneralRe: sql String seach based on other Column Pin
Vimalsoft(Pty) Ltd18-Apr-07 3:24
professionalVimalsoft(Pty) Ltd18-Apr-07 3:24 
GeneralRe: sql String seach based on other Column Pin
kubben18-Apr-07 3:33
kubben18-Apr-07 3:33 
GeneralRe: sql String seach based on other Column Pin
Vimalsoft(Pty) Ltd18-Apr-07 3:36
professionalVimalsoft(Pty) Ltd18-Apr-07 3:36 
GeneralRe: sql String seach based on other Column Pin
Vimalsoft(Pty) Ltd18-Apr-07 3:41
professionalVimalsoft(Pty) Ltd18-Apr-07 3:41 
GeneralRe: sql String seach based on other Column Pin
kubben18-Apr-07 3:56
kubben18-Apr-07 3:56 
GeneralRe: sql String seach based on other Column Pin
Vimalsoft(Pty) Ltd18-Apr-07 4:19
professionalVimalsoft(Pty) Ltd18-Apr-07 4:19 
GeneralRe: sql String seach based on other Column Pin
Vimalsoft(Pty) Ltd18-Apr-07 3:54
professionalVimalsoft(Pty) Ltd18-Apr-07 3:54 
GeneralRe: sql String seach based on other Column(Thanks i Got it) Pin
Vimalsoft(Pty) Ltd18-Apr-07 4:04
professionalVimalsoft(Pty) Ltd18-Apr-07 4:04 
Questionsaving and then undoing the changes of an insert statment Pin
steve_rm18-Apr-07 1:41
steve_rm18-Apr-07 1:41 
AnswerRe: saving and then undoing the changes of an insert statment Pin
kubben18-Apr-07 3:03
kubben18-Apr-07 3:03 
QuestionRe: saving and then undoing the changes of an insert statment Pin
steve_rm18-Apr-07 3:59
steve_rm18-Apr-07 3:59 
AnswerRe: saving and then undoing the changes of an insert statment Pin
kubben18-Apr-07 5:05
kubben18-Apr-07 5:05 
QuestionINNER JOIN on NUll Data problem Pin
Sam Heller18-Apr-07 0:20
Sam Heller18-Apr-07 0:20 
AnswerRe: INNER JOIN on NUll Data problem Pin
Pete O'Hanlon18-Apr-07 0:50
mvePete O'Hanlon18-Apr-07 0:50 
GeneralRe: INNER JOIN on NUll Data problem Pin
Sam Heller18-Apr-07 1:25
Sam Heller18-Apr-07 1:25 
GeneralRe: INNER JOIN on NUll Data problem Pin
Pete O'Hanlon18-Apr-07 1:53
mvePete O'Hanlon18-Apr-07 1:53 
GeneralRe: INNER JOIN on NUll Data problem Pin
Sam Heller18-Apr-07 2:03
Sam Heller18-Apr-07 2:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.