You know, in real circumstances, there are many developers. One developer checks for both NULL and zero-length string, when writing a comparison in SQL, another forgets. Although shouldn't be allowed,...

Thank you, Mark! It would be nice to have a little SP which goes from filed to filed in each table, checks if a field type is varchar and if...

I'm sorry I'll be on a vacation for 2 weeks. I'll check it and post results when I back.

ty

I'll double-check and post result here, thank you.

http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 doesn't seem to work any more. What is a correct link, please?