I need to match on five characters regarless where they are at in the string.
the code should be something like this but 5 chars on either side
select a.legal_name, b.dba_name
from table_1 as a
inner join table_2 as b
on '%'+a.legal_name+'%' like '%'+b.dba_name+'%'
I want to take a string of five chars in the a.legal_name and match it to any five characters in the dba name
legal name - North Sunrise Store
dba name - Northwest Sunrise Store
I want to take the string of 5 chars anywhere in legal name and dba and match it
so I should be able to pull this multiple times with the 5 char strings matching anywhere
should match on North, sunri, store, etc.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…