Click here to Skip to main content
15,443,778 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
xodeblack20-Aug-09 21:25
Memberxodeblack20-Aug-09 21:25 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 1:21
MemberAshfield21-Aug-09 1:21 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
xodeblack21-Aug-09 1:28
Memberxodeblack21-Aug-09 1:28 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 4:20
MemberAshfield21-Aug-09 4:20 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Coding C#20-Aug-09 22:25
MemberCoding C#20-Aug-09 22:25 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
David Skelly20-Aug-09 22:32
MemberDavid Skelly20-Aug-09 22:32 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 1:19
MemberAshfield21-Aug-09 1:19 
QuestionLIKE Predicate Pin
TheIdleProgrammer20-Aug-09 3:50
MemberTheIdleProgrammer20-Aug-09 3:50 
Hi guys,

I'm struggling with something conceptually that maybe somebody would be able to help me with. I'm writing an application to match vehicles in one database to vehicle in another database. As you can imagine there are difference all over the place so there will be a lot of manual matching to be done but I'm doing my best to cut down on the amount of manual work where possible. The LIKE predicate has definitely been my friend here, but how can I make it work the other way around, i.e. instead of C_Model LIKE '%Fiesta%' I could do with 'Fiesta' LIKE %C_Model%. If you know what I mean?

For instance I can match this:

DB1          DB2
'Fiesta'  -> 'Fiesta 1'
          -> 'Fiesta 2'
          -> 'Fiesta 3'


...but I don't know how to go this way:

DB1           DB2
'306 -97' -> '306'
'306 97-' -> '306'



Cheers,

Chris Chambers.
AnswerRe: LIKE Predicate Pin
Mycroft Holmes20-Aug-09 4:17
professionalMycroft Holmes20-Aug-09 4:17 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 4:28
MemberTheIdleProgrammer20-Aug-09 4:28 
GeneralRe: LIKE Predicate Pin
Mycroft Holmes20-Aug-09 13:15
professionalMycroft Holmes20-Aug-09 13:15 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 22:10
MemberTheIdleProgrammer20-Aug-09 22:10 
GeneralRe: LIKE Predicate Pin
Mycroft Holmes21-Aug-09 0:33
professionalMycroft Holmes21-Aug-09 0:33 
GeneralRe: LIKE Predicate Pin
David Skelly20-Aug-09 22:53
MemberDavid Skelly20-Aug-09 22:53 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 23:07
MemberTheIdleProgrammer20-Aug-09 23:07 
AnswerRe: LIKE Predicate Pin
Luc Pattyn20-Aug-09 4:58
sitebuilderLuc Pattyn20-Aug-09 4:58 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 22:11
MemberTheIdleProgrammer20-Aug-09 22:11 
QuestionSql Problem Pin
AhmedGebaly19-Aug-09 23:37
MemberAhmedGebaly19-Aug-09 23:37 
AnswerRe: Sql Problem Pin
David Skelly20-Aug-09 2:26
MemberDavid Skelly20-Aug-09 2:26 
AnswerRe: Sql Problem Pin
Kschuler20-Aug-09 3:17
MemberKschuler20-Aug-09 3:17 
AnswerRe: Sql Problem Pin
Jerry Hammond20-Aug-09 3:41
MemberJerry Hammond20-Aug-09 3:41 
Questionset row number in select query Pin
nainakarri19-Aug-09 20:34
Membernainakarri19-Aug-09 20:34 
AnswerRe: set row number in select query Pin
_Damian S_19-Aug-09 20:41
professional_Damian S_19-Aug-09 20:41 
GeneralRe: set row number in select query Pin
nainakarri19-Aug-09 20:44
Membernainakarri19-Aug-09 20:44 
GeneralRe: set row number in select query Pin
Coding C#20-Aug-09 3:36
MemberCoding C#20-Aug-09 3:36 

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.