Are you expecting to store japanese or foreign languages in that table?

If not you can use varchar on all Fields.

The concat field can be dropped as it is the aplication's...

17*255*2 = 8670 + 8000 = 16670, so 16845 doesn't seem far off the total size.

Run this for the exact total :

Select SUM(C.Length) as Length from dbo.SysColumns C where...

And read this :

Rules of Data Normalization

Please repost your current table definition.

nvarchar = 2 bytes per character, so you just the Address_Concat field is worth 8000, which is already very close to the limit.

If you make an unencrypted version (I mean EXACT COPY/PASTE). Does it work or does it still have the problem?

Make a new calculated column (with the replaced version). Index it and use it in the join.

Nice work... too bad I won't ever need that .

"It should give error when execute the select statement."

What statement is that??

HTH = Happy to help. (can also mean Hope this helps)

I can't post it untill I'm sure the thread is closed...

It's a secret organisation... and I already said too much .

Governement is not meant to be entertaining .

Ya good luck with that... you're gonna need it.

It simply wraps the description with spaces so that you get a hit.

Hehe, those 30 hours of C++ are finally paying off .