trknssr
asked on
trim all field values in a table
I have a table with several fields. I am trying to trim the spacing in the values in each field.
I know that I can trim a value in a field but how to trim the whole field.
Thanks,
TK
I know that I can trim a value in a field but how to trim the whole field.
Thanks,
TK
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you have field that are defined as CHAR(x), you should rather define the m into VARCHAR(x)
you can do an update for each column like
update mytable
set myfield1 = LTRIM(RTRIM(myfield1))), myfield2=LTRIM(RTRIM(myfie
hope this helps a bit
bruintje