SQL Matching a string that contains a string
I have two tables in database.
Both tables have a business name column but not always going to be the same.
for example tbl 1 has a business name of 'Aone Dental Practices Limited TA Jaws Dental' and Tbl 2 has a business name of 'Jaws Dental'. I want to be able to join these together as Jaws Dental is visible in both.
I can't seem to get the Like clause working for this.
tried
Tbl1_BusinesName Like '%' + Tbl2_BusinesName + '%'
sql tsql wildcard like ssms-2017
edited Nov 21 '18 at 15:26
Roman Pokrovskij
4,31095080
asked Nov 21 '18 at 14:11
Sam ParkySam Parky
196
add a comment |
I have two tables in database.
Both tables have a business name column but not always going to be the same.
for example tbl 1 has a business name of 'Aone Dental Practices Limited TA Jaws Dental' and Tbl 2 has a business name of 'Jaws Dental'. I want to be able to join these together as Jaws Dental is visible in both.
I can't seem to get the Like clause working for this.
tried
Tbl1_BusinesName Like '%' + Tbl2_BusinesName + '%'
sql tsql wildcard like ssms-2017
edited Nov 21 '18 at 15:26
Roman Pokrovskij
4,31095080
asked Nov 21 '18 at 14:11
Sam ParkySam Parky
196
what is your expected output?
– Sahil Anand
Nov 21 '18 at 14:16
add a comment |
I have two tables in database.
Both tables have a business name column but not always going to be the same.
for example tbl 1 has a business name of 'Aone Dental Practices Limited TA Jaws Dental' and Tbl 2 has a business name of 'Jaws Dental'. I want to be able to join these together as Jaws Dental is visible in both.
I can't seem to get the Like clause working for this.
tried
Tbl1_BusinesName Like '%' + Tbl2_BusinesName + '%'
sql tsql wildcard like ssms-2017
edited Nov 21 '18 at 15:26
Roman Pokrovskij
4,31095080
asked Nov 21 '18 at 14:11
Sam ParkySam Parky
196
I have two tables in database.
Both tables have a business name column but not always going to be the same.
for example tbl 1 has a business name of 'Aone Dental Practices Limited TA Jaws Dental' and Tbl 2 has a business name of 'Jaws Dental'. I want to be able to join these together as Jaws Dental is visible in both.
I can't seem to get the Like clause working for this.
tried
Tbl1_BusinesName Like '%' + Tbl2_BusinesName + '%'
sql tsql wildcard like ssms-2017
sql tsql wildcard like ssms-2017
edited Nov 21 '18 at 15:26
Roman Pokrovskij
4,31095080
asked Nov 21 '18 at 14:11
Sam ParkySam Parky
196
edited Nov 21 '18 at 15:26
Roman Pokrovskij
4,31095080
asked Nov 21 '18 at 14:11
Sam ParkySam Parky
196
edited Nov 21 '18 at 15:26
Roman Pokrovskij
4,31095080
edited Nov 21 '18 at 15:26
Roman Pokrovskij
4,31095080
edited Nov 21 '18 at 15:26
Roman Pokrovskij
4,31095080
4,31095080
asked Nov 21 '18 at 14:11
Sam ParkySam Parky
196
asked Nov 21 '18 at 14:11
Sam ParkySam Parky
196
asked Nov 21 '18 at 14:11
Sam ParkySam Parky
196
196
what is your expected output?
– Sahil Anand
Nov 21 '18 at 14:16
add a comment |
what is your expected output?
– Sahil Anand
Nov 21 '18 at 14:16
what is your expected output?
– Sahil Anand
Nov 21 '18 at 14:16
what is your expected output?
– Sahil Anand
Nov 21 '18 at 14:16
add a comment |
1 Answer
1
active
oldest
votes
This query should work :
SELECT *
FROM Table1 T1
LEFT JOIN Table2 T2 ON T1.BusinesName LIKE '%'+TS.BusinesName+'%'
answered Nov 21 '18 at 14:25
Zeki GumusZeki Gumus
1,382212
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53413953%2fsql-matching-a-string-that-contains-a-string%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
This query should work :
SELECT *
FROM Table1 T1
LEFT JOIN Table2 T2 ON T1.BusinesName LIKE '%'+TS.BusinesName+'%'
answered Nov 21 '18 at 14:25
Zeki GumusZeki Gumus
1,382212
add a comment |
This query should work :
SELECT *
FROM Table1 T1
LEFT JOIN Table2 T2 ON T1.BusinesName LIKE '%'+TS.BusinesName+'%'
answered Nov 21 '18 at 14:25
Zeki GumusZeki Gumus
1,382212
add a comment |
This query should work :
SELECT *
FROM Table1 T1
LEFT JOIN Table2 T2 ON T1.BusinesName LIKE '%'+TS.BusinesName+'%'
answered Nov 21 '18 at 14:25
Zeki GumusZeki Gumus
1,382212
This query should work :
SELECT *
FROM Table1 T1
LEFT JOIN Table2 T2 ON T1.BusinesName LIKE '%'+TS.BusinesName+'%'
answered Nov 21 '18 at 14:25
Zeki GumusZeki Gumus
1,382212
answered Nov 21 '18 at 14:25
Zeki GumusZeki Gumus
1,382212
answered Nov 21 '18 at 14:25
Zeki GumusZeki Gumus
1,382212
answered Nov 21 '18 at 14:25
Zeki GumusZeki Gumus
1,382212
1,382212
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53413953%2fsql-matching-a-string-that-contains-a-string%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
what is your expected output?
– Sahil Anand
Nov 21 '18 at 14:16