Test values by length

Calc len Type Chars
11 Alphanum 12345678END
11 Alphanum+Space 12345678END
28 Alphanum 123456789a123456789b12345999
28 Num 1234567891123456789212345999
29 Alphanum 123456789a123456789b123456END
29 TH !#$%&'()*+,-./:;=?@[]_`{|}~ Z
34 Alphanum 123456789a123456789b123456789c1END
35 TH A Zaz09!#$%&'()*+,-./:;=?@[]_`{|}~Z
35 Alphanum 123456789a123456789b123456789c12END
70 Alphanum 123456789a123456789b123456789c123456789d123456789e123456789f1234567END
140 Alphanum 123456789a123456789b123456789c123456789d123456789e123456789f123456789g123456789h123456789i123456789j123456789k123456789l123456789m1234567END
200 Alphanum 123456789a123456789b123456789c123456789d123456789e123456789f123456789g123456789h123456789i123456789j123456789k123456789l123456789m123456789n123456789o123456789p123456789q123456789r123456789s1234567END
Calc len Type Chars
11 Alphanum+Space 1234567 END
28 Alphanum+Space 123456789a 23456789b 2345999
29 Alphanum+Space 123456789a 23456789b 23456END
34 Alphanum+Space 123456789a 23456789b 23456789c1END
35 Alphanum+Space 123456789a 23456789b 23456789c12END
70 Alphanum+Space 123456789a 23456789b 23456789c 23456789d 23456789e 23456789f 234567END
140 Alphanum+Space 123456789a 23456789b 23456789c 23456789d 23456789e 23456789f 23456789g 23456789h 23456789i 23456789j 23456789k 23456789l 23456789m1234567END
200 Alphanum+Space 123456789a 23456789b 23456789c 23456789d 23456789e 23456789f 23456789g 23456789h 23456789i 23456789j 23456789k 23456789l 23456789m 23456789n 23456789o 23456789p 23456789q 23456789r 23456789s 234567END
Calc len Type Chars
37 TH A Zaz09!#$%&'()*+,-./:;=?@[]_`{|}~END

COOP SQL

SELECT * FROM [OnlineLookup_UAT].[Risk].[UnchallengedPayments]
 where 1 = 1
 and customerid in ('5589039','6000304', '6003143','6843952','6800659');

select * from [OnlineLookup_UAT].[Risk].[VerifiedPayments]
 where 1 = 1
 and customerid in ('5589039','6000304', '6003143','6843952','6800659');


 delete from [OnlineLookup_UAT].[Risk].[UnchallengedPayments]
 where customerid in ('5589039','6000304', '6003143','6843952','6800659');
 delete from [OnlineLookup_UAT].[Risk].[VerifiedPayments]
 where customerid in ('5589039','6000304', '6003143','6843952','6800659');