Mike,

Check DATALENGTH() function in BOL.

>Hello,
>In my WHERE clause I am trying to make a condition stating "When the length of FIELDA is greater than 4" but I can't find the right function. I tried CHAR_LENGTH and that wouldn't work. I also tried LENGTH and I don't think it was doing what I thought it was. Any suggestions?
>
>MAC