Ltrip update error

[lizarde03]

I'm trying to Ltrim leading spaces in a text field. I have checked the table design and there are no validation rules, no keys, or anything else that could cause a problem and data type is set to text. However, when I try to do the update, I get the big long error saying that 0 records were updated due to key violations and validation errors.. Any suggestions?

 

[cghoga]

Insert this in SQL portion:

UPDATE YourTable SET YourTable.YourField = LTrim([YourField]);

Hope this helps you.

 

[lizarde03]

That's what I did..and I get the validation rule error.