varchar 与varchar(max)

declare @test table(
    name varchar(100),
    password varchar(max)
)
insert into @test values('woaidaddfd','aaa')
insert into @test values('woaidaidddd','bbb')
insert into @test values('woaidbidddd','ccc')
insert into @test values('woaidcifffd','dddd')
select * from @test
select * from @test where patindex('%aida%',name) > 0
select *,datalength(patindex('%d_*i%',name)),datalength(patindex('%b_*i%',password)) from @test where patindex('%d_i%',name) > 0