truncate location and signature?

[underdog]

passing along what i figured out this evening in case it is of use to anyone else.

these statements work with version 3, they blank out the field entries that are over a certain length for the signature and for one of the customizable profile fields (in this case field2):

SELECT signature
FROM usertextfield
WHERE LENGTH(signature)>250

UPDATE usertextfield SET signature = ""
WHERE LENGTH(signature)>250

**********

SELECT userid, field2
FROM userfield
WHERE LENGTH(field2)>25

UPDATE userfield SET field2 = ""
WHERE LENGTH(field2)>25