When I do the following, I get 4... you can use this in the where clause.
select len('1234 ') as wayne
>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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown