Join where LIKE?
See tables below. The table PipeFull contains varchars up to 4,000 characters long that may or may not contain an acct number from table la_missing_nate.
The following SQL is running, but is this proper?
select a.*, b.*
from dbo.la_missing_nate a
join dbo.PipeFull b
on b.test like a.acct
CREATE TABLE [dbo].[PipeFull](
[test] [varchar](max))
CREATE TABLE [dbo].[la_missing_nate](
[acct] [nvarchar](50))
The following SQL is running, but is this proper?
select a.*, b.*
from dbo.la_missing_nate a
join dbo.PipeFull b
on b.test like a.acct
CREATE TABLE [dbo].[PipeFull](
[test] [varchar](max))
CREATE TABLE [dbo].[la_missing_nate](
[acct] [nvarchar](50))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select a.*, b.*
from dbo.la_missing_nate a
join dbo.PipeFull b
on b.test = a.acct