Please would someone kindly clarify for me which is the most efficient way to determine whether a string (VARCHAR) value has a zero length. I am sure that the answer would vary according to circumstances, but there must be a few common rules. For example, which of the following is most efficient: 1. LEN( @StringValue) = 0 2. @StringValue = '' Any assistance would be greatly appreciated.